Help Needed With DSum?

[Guest]

Hi

Please can anyone help me with the following query:-

I am trying to create an inventory application in Access 2007.
I have created a Stock table (info stored on each shoe), a Warehouse table
(where stock is kept). A Transactions table (info stored on each transaction).
I also have a sales table that I want it to record items that go in and out
of the warehouse and an orders table that records items coming in.

How would I get both of these tables to add records to the Transaction table?

I have also created a DSUM function:- (which I think is correct)
=DSUM("[Quantity]","tblTransactions","[Stock ID] = " & [tblStock].[Stock ID]
& " AND [Transaction Type] = 'Incoming'") -
DSUM("[Quantity]","tblTransactions","[Stock ID] = " & [tblStock].[Stock ID] &
" AND [Transaction Type] = 'Outgoing'")

But where in a query should I put this and what other fields should I
include, so it will work?

I hope my explanation is clear to you.
Please do not hesitate to ask me any questions if you need to clarify before
being able to answer my question.

Thanks for all your help,
Louisa.

 

[Guest]

Where do you want to display this Sum?
In the report/form

 

[Guest]

I would like to see it in the quantity in a report,
Thanks

Where do you want to display this Sum?
In the report/form

--
Good Luck
BS"D

Hi

Please can anyone help me with the following query:-

I am trying to create an inventory application in Access 2007.
I have created a Stock table (info stored on each shoe), a Warehouse table
(where stock is kept). A Transactions table (info stored on each transaction).
I also have a sales table that I want it to record items that go in and out
of the warehouse and an orders table that records items coming in.

How would I get both of these tables to add records to the Transaction table?

I have also created a DSUM function:- (which I think is correct)
=DSUM("[Quantity]","tblTransactions","[Stock ID] = " & [tblStock].[Stock ID]
& " AND [Transaction Type] = 'Incoming'") -
DSUM("[Quantity]","tblTransactions","[Stock ID] = " & [tblStock].[Stock ID] &
" AND [Transaction Type] = 'Outgoing'")

But where in a query should I put this and what other fields should I
include, so it will work?

I hope my explanation is clear to you.
Please do not hesitate to ask me any questions if you need to clarify before
being able to answer my question.

Thanks for all your help,
Louisa.