Link external query result to report footer. (1 Viewer)

[gcormier]

I have a report that uses one query as its data source. I have another query that only has one number as the result... let's say that the number is 212. I would like to have that number appear in the report footer. When I use the build function in the report footer, I just cannot get the value to appear. When I run the report it won't recognize that one text box. Is there an easy way to get this one number to show? Thanks. -GAC

 

[Fornatian]

First things first:

If it's just one number you are after could you not use a DLOOKUP function instead of a query?

If you can't figure it out that way, why not drop the info into the report footer as a subform with only one text box.

I haven't tried it but I'm sure with a bit of fiddling it will work.

 

[gcormier]

Thanks, "F" ... I always forget about dragging and dropping. It worked perfectly. -G