Counting Down? Hellp

[Adam]

I am trying to count down how many "sessions" a client has left.
I have a table where i keep the total number of sessions a client purchased
(ie. they buy 12 and that is recordeed in the sales table with a sale ID
along with a package type ID identifying that package of 12).
I have another table holding the attributes of a session (i.e date it
occured, etc.).
I want to be able, as i a log that a session occured (fields include a check
box stating whether session completed or not, the date, the client name, and
the sale id which tells the size of the session purchased; 12, 24, etc.), be
able to deduct that session from the total the client purchased and do a
count down. How can perform this kind of count down?

 

[John W. Vinson]

I am trying to count down how many "sessions" a client has left.
I have a table where i keep the total number of sessions a client purchased
(ie. they buy 12 and that is recordeed in the sales table with a sale ID
along with a package type ID identifying that package of 12).
I have another table holding the attributes of a session (i.e date it
occured, etc.).
I want to be able, as i a log that a session occured (fields include a check
box stating whether session completed or not, the date, the client name, and
the sale id which tells the size of the session purchased; 12, 24, etc.), be
able to deduct that session from the total the client purchased and do a
count down. How can perform this kind of count down?

A simple subtraction. It's not clear of what the context is, but on a Form you
could have a textbox with a control source like

=DLookUp("[SessionsPurchased]", "[Sales]", "[SaleID] = " & SaleID) -
DCount("*", "[Sessions]", "[ClientID] = " & [ClientID])

 

[KARL DEWEY]

Why not use the log?
On sale run append query with count down list.
ClientID -
SessionNUM - integer
SessionDate - DateTime
Complete - Yes/No

On updating (SessionDate, Complete) append new record with SessionNUM =
SessionNUM -1 unless your rule is to allow repeat of incomplete session.
Repeat appends with same SessionNUM.