combining two queries

T

tom

I have a query that finds the running sum of Inventory
using the dsum function. I have another query that
finds the running sum of Accounts Receivable again
using the same method.

I have a list box on a form showing the data based on
the inventory running sum query. I would like this
list box to have the AR data in it also.

Is this possible?
 
D

Dale Fye

Tom,

I'm assuming that what you mean by a running Inventory and running Accounts
Recievable is that these queries have a date field, and sum some other field
(or combination of fields) for all values before that date, for a particular
product. Is that a valid assessment?

Can you give us the field name in your queries and a couple of sample
records from each. If my assumption above is correct, then the critical
question is "are you certain that you have an entry in each table for each
date in the range you want to display?"

Dale
 
T

tom

This is the query I am basing the list box on. I want
to combine this with an exactly similar one for
Accounts Receivable.

SELECT InventoryBalance.Date, DatePart("y",[Date]) AS DayOfYear,
DSum("InventoryBalance","InventoryBalance","DatePart('y', [Date])<=" &
[DayOfYear] & "") AS RgBlceInventory
FROM InventoryBalance;
 
Top