D
DrPepsi
First, don't laugh at my hobby. I am trying to develop a database to track
my rather extensive gift card collection. I am using Access 2003. I have
the database / table set up as well as the forms, queries and reports. (that
whole learning process practically proved to be a second hobby of it's own).
My problem is that my table / database has a Quantity field. I want this
Quantity field to automatically calculate the total Quantity of a single gift
card design for me based on the data entry I input from the Form. I want
this Quantity field to auto-calculate and auto-update and display on the Form
as I enter the data.
An example is that I have 5 copies of a special edition gift card. This
would be a Target, Christmas, Special Edition gift card. When entering the
various gift card data into the database, by using the Form I, will key into
the various categories listed above to indicate that I have 1 QTY filed in
the Target file, 1 QTY filed in the Christmas file, and 3 QTY in the Special
Edition file.
I want the Form to display the auto-calculate and auto-update (display) what
the grand total quantity (this quantity field is located in my table) is of
this gift card that I have in stock each time I enter a Quantity into the
different categories.
I have tried playing with Data Type from the Design View of the Table and
attempted to add other fields of the Table into the Quantity field with no
success. I would greatly appreciate any advice or direction anyone can offer.
Thanks in advance - Yvette
my rather extensive gift card collection. I am using Access 2003. I have
the database / table set up as well as the forms, queries and reports. (that
whole learning process practically proved to be a second hobby of it's own).
My problem is that my table / database has a Quantity field. I want this
Quantity field to automatically calculate the total Quantity of a single gift
card design for me based on the data entry I input from the Form. I want
this Quantity field to auto-calculate and auto-update and display on the Form
as I enter the data.
An example is that I have 5 copies of a special edition gift card. This
would be a Target, Christmas, Special Edition gift card. When entering the
various gift card data into the database, by using the Form I, will key into
the various categories listed above to indicate that I have 1 QTY filed in
the Target file, 1 QTY filed in the Christmas file, and 3 QTY in the Special
Edition file.
I want the Form to display the auto-calculate and auto-update (display) what
the grand total quantity (this quantity field is located in my table) is of
this gift card that I have in stock each time I enter a Quantity into the
different categories.
I have tried playing with Data Type from the Design View of the Table and
attempted to add other fields of the Table into the Quantity field with no
success. I would greatly appreciate any advice or direction anyone can offer.
Thanks in advance - Yvette