Can Datasheet View do calculations?

[jlathem]

Hey guys,

I need assistance writing a query in MS ACCESS.
I have a table called PrePaidCards that holds my basic data about the cards.

When a card is sold the basic information is entered into the PrePaidCard table (Date sold, amount purchased, etc…) along with a field named Empty. Empty is set by default to 0 (No).

Each time the card is used a “one to many” transaction is logged into the Sale table with the Date of the sale, CardAmount, State, etc… The Sale table has a field called PrePaidCardID that links the records.

There is also a Comment table where a “one to many” comment may be captured. The Comment table has a field called PrePaidCardID that links the records.

I am using the following query to get a Data Sheet View of all cards that have NOT been exhausted.

[FONT=Calibri][SIZE=3]SELECT PrePaidCard.*[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]FROM PrePaidCard[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]WHERE PrePaidCard.Empty Like No;[/SIZE][/FONT]

This works fine to get a basic list however, I need a list of cards with a balance and their comments and the amount of remaining funds on each card too (CardAmount - all SaleAmount found in the Sale table). Can this be done using Datasheet View?

Thanks in advance for any help you can give.

James