access query

  • Thread starter Thread starter Munnabhai
  • Start date Start date
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.
 
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

DLookUp #Error 7
ApplyFilterMacro 4
Query to show latest price based on dates 2
Revised Calculation 11
Monitoring Inventory Transactions 3
Query if price is not null 1
Access Updating inventory levels 0
Modify Lookup 5

Back
Top