access query

M

Munnabhai

I have two Table Products & Transaction. I made query that result me
productID, ProductName, from Products and UnisInStock from Transaction.
I want another three column ,UnitInStock of yesterday, QtyReceived
Today, QtyIssue Today in my query.
 
A

Arvin Meyer [MVP]

Munnabhai said:
I have two Table Products & Transaction. I made query that result me
productID, ProductName, from Products and UnisInStock from Transaction.
I want another three column ,UnitInStock of yesterday, QtyReceived
Today, QtyIssue Today in my query.
Click to expand...

UnitsInStockYesterday: IIf([ReceivedDate]<Date(),[UnitsInStock,0)

QtyReceivedToday: IIf([ReceivedDate]=Date(),[UnitsInStock,0)

QtyIssued: [QtyReceivedToday]-[UnitsInStockYesterday]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ApplyFilterMacro 4
Query to show latest price based on dates 2
Query if price is not null 1
Modify Lookup 5
Access Updating inventory levels 0
Filtering a Lookup Box 4
Access Control on subform / combo box requesting parameter 0
Duplicates not added in a Cross Tab Query 4

Top