How to make a report from unrelated tables!!

[DaniBoy]

Hello,

One more thing and am done with this program!!! Ok, I am making a little program that takes invoices and orders, I also add it a Expenses.

This is just a simple application, people buy on credit, and pay every to weeks.

Ok everything works great, but now I want to make a report that has this three tables together:

tblInvoices,tblInvoicesDetail and tblExpenses. With the tblInvoices and tblInvoiceDetail I have no problem. with tblExpenses I do

I want to be able to do a parameter date range, this way I can get the total of expenses and the total sales for a date range. The problem is that Invoices have there own date field and Expenses do to.

I need to make it so the date range only parameter is only asked once.

another thing, there is no ralationship between the tblExpenses and the other tablws.

Thank you

Have a nice weekend and god bless you

 

[Travis]

Create a form that has the Date on it and set the Query's Parameter equal to the Forms Field:

Example:

Place this in the QBE Grid for both Queries:

=Forms![The Form Name].[The Date Field Name]


When the Report opens it will limit both queries by the date on the form, thus eliminating the need to type the date in twice.