Sidney Lynn
New member
- Local time
- Today, 12:34
- Joined
- Jun 4, 2003
- Messages
- 6
QueryA has records for all 12 months, and has fields named: Month#, AccountType, SalesRep, and Sales$. A new query, QueryB, has these same fields, but I enter a Month# from a Dialog Form and QueryB gives me values for that particular month. (The Month# is just a number and not a datefield; there is no year data.)
I want to add a new column to QueryB that will calculate the Year-To-Date Sales from the beginning of the year (Month #1) to Month X -- X being the month# I entered into the Dialog Form.
Can this be done? The sales figures for all 12 months is in QueryA that QueryB is based upon. I’ve tried various expressions but nothing works. If I can get this to work it will save me lots of extra queries and subreports!!! Thanks.
I want to add a new column to QueryB that will calculate the Year-To-Date Sales from the beginning of the year (Month #1) to Month X -- X being the month# I entered into the Dialog Form.
Can this be done? The sales figures for all 12 months is in QueryA that QueryB is based upon. I’ve tried various expressions but nothing works. If I can get this to work it will save me lots of extra queries and subreports!!! Thanks.