DLookUp on Report

[lilanngel via AccessMonster.com]

I am trying to do a DLookUp in a report called "Status (Table)", but it does
not work.

=DLookUp("Field1","Combo Options","id = " & [Reports]![Status (Table)]!
[Summary Slide])

Basically [Summary Slide] is a number (from 1-4) and the number corresponds
to a "status". (e.g. 1="N/A", 2="Blank", 3="Incomplete", 4="Complete")

The Combo Options Table looks like this:

id Field1
1 N/A
2 Blank
3 Incomplete
4 Complete

I'm not sure if the formula is incorrect... or if I am referencing the wrong
things.

Thanks for all your help!

 

[Douglas J. Steele]

See whether putting square brackets around the table name ("[Combo
Options]") makes any difference.

Far simpler, though, would be to create a query that joins your existing
table to the Combo Options table and use that query as the RecordSource for
the report.

 

[lilanngel via AccessMonster.com]

Thanks, Douglas.

I tried putting square brackets around the table name, but it still returns
#Error.

How would I go about joining those two tables using a query?

Thanks!

See whether putting square brackets around the table name ("[Combo
Options]") makes any difference.

Far simpler, though, would be to create a query that joins your existing
table to the Combo Options table and use that query as the RecordSource for
the report.

I am trying to do a DLookUp in a report called "Status (Table)", but it
does

[quoted text clipped - 20 lines]

Thanks for all your help!

 

[lilanngel via AccessMonster.com]

Never-mind, I've figured it out.

Thanks!

See whether putting square brackets around the table name ("[Combo
Options]") makes any difference.

Far simpler, though, would be to create a query that joins your existing
table to the Combo Options table and use that query as the RecordSource for
the report.

I am trying to do a DLookUp in a report called "Status (Table)", but it
does

[quoted text clipped - 20 lines]

Thanks for all your help!