User Profile

Collapse

Profile Sidebar

Collapse
pkumar74
pkumar74
Last Activity: Oct 3 '07, 12:25 PM
Joined: Oct 2 '07
Location: CANADA
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pkumar74
    replied to Dlookup Function Help ???
    in Access
    Thank you for your early reply:

    but if I change the ProductID to ProductName, then I get nothing in the field.

    My primary search is based on productid & not on product name. for ex.

    ProductId ProductName UnitPrice

    1234 ABC $ 20
    2345 DEF $ 10
    6789 PQR ...
    See more | Go to post

      Leave a comment:

    • pkumar74
      started a topic Dlookup Function Help ???
      in Access

      Dlookup Function Help ???

      Hi .........

      I'm not good at Access but always try to make things work.....'cause i have habbit of correcting my self.

      I have a database , in which I have a form for purchase orders with the following fields.
      ProductId
      ProductDescript ion
      UnitPrice

      What I'm trying to do is to dlookup is the Price & the ProductDescript ion, when ProductId is typed.

      DLookUp("UnitPr ice","Products" ,"ProductID...
      See more | Go to post
      No activity results to display
      Show More
      Working...