Storing the values from a parameter query for use in report

dragginthru

HMTL & CCS expert
Local time
Today, 07:54
Joined
Sep 21, 2005
Messages
63
OK I have a query which selects training courses attended, between user specified start and finish dates.

The query works fine, and the report displays just fine -

What I would like to do is to put those dates at the top of the report ie the title of the report:

TRAINING SPEND SUMMARY FROM 12/05/04 to 12/06/04

However as these values do not reside in a table at present, I don't know how to call the values in the report like I would with other fields.... :confused:
 
Pass the parameters to the query via a form, you can then reference those textboxes on your report like so
=Forms!YourForm!YourTextbox
 
Rich said:
Pass the parameters to the query via a form, you can then reference those textboxes on your report like so
=Forms!YourForm!YourTextbox

OK cool ill try that in a mo!

PS didnt mean to double post - got a "page cannot be displayed", but i always copy posts to clipboard in case i lose it, so when it did that i just did a new thread coz when i went back in browser, the text was gone! and hence the slightly different title!
 

Users who are viewing this thread

Back
Top Bottom