Merging two queries

[Guest]

I need help. I have two seperate queries with a built expression in each
from one table. For example, I would like to calculate the last years total
to this years sum. Everytime I attempt to join these queries, I can never
type in the form where I add data. I just get a beeping noise. I have all
the calulation set and just need help with this. I can be more specific, but
the problem on its surface does not seem that complex. Please help

Jim

 

[G. Vaught]

You are joining one table using two queries, which is creating an non
updateable query.
Why are you adding last years total in the form. Would this be better served
in a report. Its moot to add a total from last year to this years totals
because the total is a collective of the records already in the table. If
you restrict your records from the table for this year and last year, you
will already have the total for both years.

 

[Guest]

G-
Thanks for the reply. I have tried to add the totals in a report, but
cannot because I cannot show last years total because it is in a different
query than from the datasourse. Additionally, I attempted to add it to the
orgininal table, but that does not keep a running total and cannot add the
calculations from the query into any table.

 

[Van T. Dinh]

Without knowing your Report, I cannot be sure but you can use a Calculated
Control on the Report using the DSum() function to show some sum (e.g. last
year sum) independent from the RecordSource of the Report.

Check Access VB Help on the DSum() function.