Candyman_mm
Registered User.
- Local time
- Today, 17:26
- Joined
- Feb 2, 2002
- Messages
- 20
I have one table with multiple fields, two of which is creating a lot of problems for me. One thing is, there is one field for the date of one cash item, the other field contains the dollar value; for example: 07/16/02 = $21,650.03. I have ran a query that represents the age of the item (current date - date displayed) = age of item. Now, how can I run a querry that returns the sum of the items that (=<30days, >0,"")and another querry that returns the value of the sum of items that are debits and items that are credits?
