How do I refer to a table field from a report? 1

[clint6]

I have a report that has a query as a data source. However, I'd like to look up a table field and add it to the report. Does anyone know how to refer to a table field from a query based report without having to add the table field to the query?

Thanks

 

[straybullet]

Check out the DLookup function

Let them hate - so long as they fear... Lucius Accius

 

[TheAceMan1]

How are ya clint6 . . .

Sample code:

[blue]= DLookup("[[i]FieldName[/i]]", "[[i]TableName[/i]]", "ID = " & Me!TextboxName)[/blue]

See Ya! . . . . . .

 

[clint6]

Thank you all very much. The dlookup function worked within the text box.

I used the following to get my dates from the Input table:
="Period Beginning " & DLookUp("[BEGDATE]","Input") & " Through " & DLookUp("[ENDDATE]","Input")

This was a previously built report from a query with other BEGDATE and ENDDATE fields from different table.

Thanks to all

 

[TheAceMan1]

clint6 . . .

BTW: [blue]Welcome to Tek-Tips![/blue] To get great answers and know whats expected of you in the forums be sure to have a look at FAQ219-2884

See Ya! . . . . . .