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?

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
--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.


"tom" wrote:

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

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;


"Dale Fye" <(E-Mail Removed)> wrote in message
news:A38BC703-EB81-4A03-A7A9-(E-Mail Removed)...
> 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
> --
> Don''t forget to rate the post if it was helpful!
>
> Email address is not valid.
> Please reply to newsgroup only.
>
>
> "tom" wrote:
>
>> 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?
>>
>>
>>