Add record to a query with totals.

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

Guest

I have a query with totals: 2 fields use the sum function.

I only want to show the CardID once, then on the same row sum the two fields
named--Add and Remove. Then take the sumofadd-sumofremove. I need these to
sum because I only want the subform to show one record (grouped by cardID)
and not 25 records (if I take the sum off.)

Here is my question: It will not let me add new records when I have Totals.
Is there a way to get around this problem?
 
When you aggregate rows together then you can't make changes. How would the
database know which record to change, delete, or add into which aggregated row
of data.

IF you describe your problem more fully, then perhaps someone can give you a solution.
 
I will have a subform that will display one row for each type of card, and
then display the sum of the card. There can be many cards for one account
(acct is the parent form). Each Card will come from tblCard--cardID,
cardName, CardTypeid (comes from another table tlbCardType). Each Card will
contain copies from tblCopies--cardid (the form will add this by default),
copyid, employeeid(comes from tblEmployees), add, and new. I need the query
to show the all the cards that the user has and then show the total number of
copies left {Total copies left = sum(new)-sum(used) for all records with the
same cardID.}
I think this should be clear, but if not please let me know.
Thanks for your help,
James
 
Back
Top