By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,479 Members | 988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,479 IT Pros & Developers. It's quick & easy.

Subtracting rows to determine actual sales

P: n/a
I'm trying to develop a database to keep track of apartments sold by
the competitors. We get the data as accumulated totals. Example: in
7/1/05 10 apartments of 3 bedrooms were sold in the building called
Chipana. Then in 12/1/05 15 have been sold, and so on.
How can I get the actual number of apartments sold between two periods?
I have the data for the inventory like this:

InventoryID DateInventory Sold DeptoID
1 1/7/05 10 1
2 1/12/05 15 1

DeptoID is the ID for a specific type of apartment within a building.

The main objective is to get a report of sales by types of apartments
(no. of bedrooms/bathrooms, etc), or other characteristics, by year.

Can I do it directly in the report? Do I need to do a query?
I'm using Access 2003.

Thanks a lot!

Oct 13 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.