Search results

The query is working fine. Thanks

Yes latest not last. Create...! I will try when the pc is available And add my comment Thank in advance

I have trans table contains Productid, price, date, supplerid feilds How can i get last price for each item and each suppliers as in picture i have same database on sql server and i got help. The sql statement works perfectly as bellow select max(date) as date, productid, max(qty) as...

hello I provide you with a database to calculate inventory by fifo method and calculate the cost of materials in sales invoices The pre-existing database (fifostock) was used for modification. ms access 2007 and apove

this project is On the basis of considering A salesperson's distribution vehicle to be treated as a warehouses

hello every bod I wanted to add a sample databas but I ran into a problem the main form[user] doesn't work when compressed by zip-drive but its works fine with rar-drive or unzipped it can any one help me to solve it and add it in sample database and Explain the purpose of this database

hello here is aContribution of me to support samples Bank cheques managment sample by access 2007

i have figured it out by create query '7' but i have about 45000 records then the the query 'qage' became somewhat cumbersome because to run 'qage' need to run 3 queries before do you have any advice to me ?

My previous post has been modified because of the wrong understanding of the problem. I wait your replies

Excuse me I face another problem The expression in field"deen" in query "Q1" work's wrongly ,if I use this case Customer1 his transaction as following 1.in 1-1-2016 invoice no-1- amount (10£) 2.in 1-3-2016 he paid (11£) 3.in1-4-2016 invoice no-2- amount (10£) another invoice At the same...

Thank you a lot That's ok

_hello This is the first post for me I have a database for the Aging receivables The problem is:When I make run "Qage"query that calculates Aging receivables depends on "id" field "Gltrans"table look in " Q1" query but I want calculates Aging receivables depends on "Opdate" The...