Make form with two unrelated tables

[DaniBoy]

Hello,
I have a table database for a small store. these are some of the tables in it:

Products
Invoice
InvoiceDetail
Orders "from suppliers"
OrderDetails
Expenses

"Its actualy in spanish"

From this tables I can get queries that give me the AvgCost of the product and the sale price of the product to get my profit.

Now, I have a table that I input all expenses that we have done, and from this I can get a total expenses.

Both queries Total Profit and Total Expenses have a Date Field, I want to be able to put parameters on both Date Fields. Ex: Between [ Start Date] and [End Date]. When I do this I have to put this in both Date Fields and it makes me input the information four times.

How can I make it so when I enter a date range I get the same parameter in both Date Fields.

DannyBoy

If you would like me to send you the Application let me know.

 

[Travis]

Make both qry's into forms.

Add them to a different form. They become Sub Forms to this new Unbound form.

Add a field for entering the date. Link Parent and Child between the Main form and each Child form.

 

[DaniBoy]

Thanks I'll try it

Thanks Travis,
Now will this wrok the same for a report? I guess you now what am trying to do!! Its like a Balance Sheet to be able to get the Gross Income and the Net Income. I will Subtract The Total Expenses from the Total Profit.


Thanks
DaniBoy

 

[Travis]

Yes.