basic calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

would like the field to be able to keep running count of items keyed in , but
then when items are taken out of field would like it to subtract from count.

Basically i have a drawer with folders that accumalate daily, but then some
are taken out daily. How can i keep this count.

what do i need to type in the field for the data base when users input the
count data. Negative value/positive values?
 
Look up the use of SUM in the help menu. SUM can be used two ways, to get a
single running total (and thuse capture any subtractions) or is can provide
an ongoing total.

B
 
Assuming you have a table named MyTable with a field named Folder, each
record records one folder and "taken out daily" means never returned. "Taken
out daily" would then mean deleting a record.

Add an unbound textbox named CountOfFolders to your form and label it Count
Of Folders. Put the following code in the form's open event:
Me!CountOfFolders = DCount("[Folder]","MyTable")

Put the following code in the form's AfterUpdate event:
Me!CountOfFolders = DCount("[Folder]","MyTable")

Your form will open with the textbox showing the current count of folders in
your table. When you add a record to your form the count of folders will
increase +1 and when you delete a record from your form, the count of
folders will decrease -1.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Back
Top