combing fields from different tables

[Brian]

I got some pointers yesterday from a menmber but haven't yet solved my
problem. I have a monthly expenses and a monthly sales report. I am trying
to combine them into one for comparative purposes. The problem is with the
dates. The "Sales Table" has a date field as does the separate "Exenses"
Table. Obviously the comparative reports need to total the sales and expense
for the same months. I am a bit too far down th line for a major re-write.

The advice I got yersterday was to create a third table (which I called
"AllDates" and imported from Execel a 10-year range of dates. My new query
joins the the two table's dates field to the 3rd table from which the date is
put in the query field but will not display all dates. Fooling around with
1-2-3 join options I can get a datasheet with all table 1 or all table 2
dates but not both.

Any one got an answer? Forgive the impertinence but if it requires a
complex WHERE statement could you spell it out for me.

Here's Hoping

 

[John W. Vinson]

I got some pointers yesterday from a menmber but haven't yet solved my
problem. I have a monthly expenses and a monthly sales report. I am trying
to combine them into one for comparative purposes. The problem is with the
dates. The "Sales Table" has a date field as does the separate "Exenses"
Table. Obviously the comparative reports need to total the sales and expense
for the same months. I am a bit too far down th line for a major re-write.

I would suggest a report (probably an unbound report) with two Subreports,
each based on a query of one of these tables. The queries could use the same
date range as criteria.

 

[Brian]

It's a direction that never ocurred to me but I can see the logic. There is
some new territory here so it may take me a while to configure the report
correctlly but at least I am digging in the right field.
Thanks

 

[John W. Vinson]

It's probably your best bet, since (I presume) there is no relationship of any
sort between sales and expenses. A Query joining the tables would be a
nightmare.