Re: DLookUp in query headache! multiple duplicate records returned

Can't you use a join query and avoid the dlookup?

<colin-whitehead@xxxxxxxxxxx> wrote in message
news:8d5c7356-bcfb-4f95-ac1b-2132cf3e757b@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have 2 tables
tblReports primary key UPN, plus numeric fields Effort, Attain, etc

tblComments numeric primary key ID & textfield Text

In the Query I select each record from tblReports using UPN and for
each of the numeric fields use DLookup to look up the Text in
tblComments.

the expression DLookUp("Text","tblComments","ID=" & tblReports!Effort)
retrives the correct text but when I use the query it produces
multiple duplicate records - (the number of duplicate records equal
the number of records in the tblComments table)

I cannot see how this is happening. Can anyone help!


.

Relevant Pages

  • DLookUp in query headache! multiple duplicate records returned
    ... tblReports primary key UPN, plus numeric fields Effort, Attain, etc ... tblComments numeric primary key ID & textfield Text ... retrives the correct text but when I use the query it produces ... multiple duplicate records - (the number of duplicate records equal ...
    (comp.databases.ms-access)
  • Re: DLookUp in query headache! multiple duplicate records returned
    ... tblReports primary key UPN, plus numeric fields Effort, Attain, etc ... tblComments numeric primary key ID & textfield Text ... retrives the correct text but when I use the query it produces ...
    (comp.databases.ms-access)
  • Re: Exporting Data as text file
    ... To have the spaces replaced with zeroes, write a query that uses the Format ... function on the numeric fields (not the Format property), ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.externaldata)
  • Re: Export problems
    ... Create a query and use the Format function in the query to convert the ... numeric fields to strings. ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.reports)
  • Re: duplicating control and incrementing another control
    ... any of the other values (or 0s for numeric fields) then just leaving them ... out of the query will work fine. ... Then switch to the SQL view of that query. ... >> dim sql as string ...
    (microsoft.public.access.formscoding)