Add Data To Report

[fenhow]

Hi,

I have a report that runs great from the query.

I want to add data on the report from a table that is not in the query. It is a fixed table with the Version and Date of Release in it. I do not want to add it to the query either as it hoses up my app for some reason.

Is there any way to do this?

I tried this in the footer of the report but it keeps showing error.

=[tblVersion]![Version Number] & [tblVersion]![Date Released]

Thanks.

Fen How

 

[pbaldy]

No that wouldn't work. You could either create a subreport based on the other table or use DLookup to get the value.

 

[fenhow]

DLookup sound promising, how would that look on my form?

I appreciate your help..

Fen

 

[pbaldy]

A textbox control source of:

=DLookup(...)

http://www.mvps.org/access/general/gen0018.htm

 

[Peter Bellamy]

Can't you add the Version table to the underlying query?