displaying a report from a query

[Uobirac]

hi all, i'm having a bit of trouble displaying a letter from a query. the letter is in the form of a report. i've created a toys database, with different loan details and need to automatically produce a reminder letter (report) when a loan return is overdue.

how would i do this? can u display a report through a query?

thanx for ur help

steve

 

[David R]

You can open a report specifically to a particular record, and if the record is based on a query that will pull in the necessary fields, then "yes".

Otherwise I'm not understanding your question. Entirely possible.

David R

 

[Uobirac]

but how do u get a query to display a report? that's wot i need to know.

i'm sure it would be an IF function, but what is the expression to display a report?

this is basically wot i'm trying to do:
IF[returned?]=no Then (display the report) otherwise, do nothing

any help much appreciated, thanx

 

[Pat Hartman]

A query doesn't display a report. If you want to base a report on a query, use the query as the report's recordsource rather than using a table. If you have not yet built the report, choose one of the report wizards and select your query as the recordsource. The wizard will build the basics and you can pretty it up later. If you have already built the report, you'll need to change the recordsource from a table to your query. If the field names didn't change, your report should still work. If your report is not presently bound to a recordsource, add the query name to the recordsource and then for the controlsource of each control, choose a field from the recordsource.