Dlookup help

[MusoNZ]

Hi people,

I have a report, which has on it a number field called 'Significance'. This is related to 'SignificanceID' in another table.

What I would like to do is replace the number 'Significance' with the corresponding text which is in the other table.

I'm using Dlookup but not getting the right results:

=DLookUp("Significance","TableSignificance","SignificanceID")

gives me the same text for all records - which isn't right.

Help please?

Thanks,

Mark.

 

[simongallop]

Why not get the report to take its data from a query rather than a table. Then in the query you could bring in the SigIDDescription field

 

[antomack]

Your current DLookup is just getting the same record over and over again.

Try the following:
=DLookUp("[Significance]","TableSignificance","[SignificanceID]=" & [Significance])