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.
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.