To attach Query to our report

F

Frank Situmorang

Hello,

Istead of making form query for Oustanding Supplier Invoices for Year End
2007, I plan to attached the Grid Query to the reports.

My question is there any way to prompt us to attach to select one query
among so many queries?.

For the Year End, I have made in the Grid Query as follows:
Invoice Date < ! Jan 2008 and Invoice Balance >0
Or Invoice Date < 1 Jan 2008 and Invvoice Balance =0 and Paid Date>31 Dec 2007

I am not too well in database design, so no SQl, I just want it to promt us
to select query, because desingn query in grid is much easier then writing it
with SQL

Thanks in advance.
 
G

Golfinray

I would either build a parameter query to select your queries (parameter
query will ask you which one you want to run) or build a from to select the
one you want. It could be done with command buttons and let the command
button wizard build it for you or some sort of box. Hope that may help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top