General discussion

Locked

Maybe this one is easier

By JoePlaisted ·
Hello,
I am hoping that this problem is easier than the last one I had as no one was able to help me at all. I have a MSAccess 2000 Database with 2 fields, one is titled "DATE" and the other is titled "SALES". Mutliple dates will be entered into this database with the amount of sales for each date. I have to be able to determine the difference between the sales on date "A" & date "B" i.e. If on 11/1/03 we sold $1,200,000.00 and on 12/1/03 we sold $1,000,000.00, the difference between the two is $200,000.00. Now I can get the query to call up any two dates in the database that I want, but I can not get either the report or the query to subtract the amount of date "A" from date "B". Can someone please tell me what I am doing wrong please?

Thank you

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by John Gordon In reply to Maybe this one is easier

You could write some VB code to assign the two values to two variables then subtract the variables and then write the answer to a field on a report or form. The code could be set to run automatically when the form or report was opened or when two dates had been selected.

If you want I could write some example code for you.

Collapse -

by JoePlaisted In reply to

Poster rated this answer.

Collapse -

by JoePlaisted In reply to Maybe this one is easier

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums