Tracking cash Orders

  • Thread starter Thread starter callieandmark
  • Start date Start date
C

callieandmark

I need to be able to run a query whereupon each time it is run, new
data that matches criteria is added to the end of the existing query
with a date when it was added.
Is this possible ? or is there a better way of doing the below..

In detail, what I have is an orders database. Some orders are on
account and some cash sales. I need to (on a daily basis) cash up and
bank the money. So, I need to know what orders have already been cashed
up and what new cash sales have been made since I last ran the query.

Any advise please ...

Many Thanks
 
I have tables :

Orders (OrderID,Customer,OrderDate)
OrderDetails(OrderID,Item,UnitPrice,Qty)
Customers(CustomerID,Name,Address,AccountCode)

The Account Code is either an 8 digit code or it reads "Cash" for a
cash sale.

I have a query which lists all the cash only jobs, and the total
ammount.


What I need to be able to do is run the query and print it out so i
have a print out of the cash jobs. The next time i run the query,
however, I need to run the it but exclude the results from the last
time so that i dont end up with duplicates.
 
You could retain the LastRun value in a table. Using Dlookup() to find the
last run value.

select * from ... WHERE OrderDate > Dlookup("LastRun","ztblAppInfo")
--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
 
Thanks for your help. Ive sorted it now.
What I did was create a table with two fields. FromDate and ToDate.
Then used a query to swap ToDate to FromDate and replace ToDate with
Now().

Worked a treat.

Many Thanks again.
 
Back
Top