Query question

  • Thread starter Thread starter wagz
  • Start date Start date
W

wagz

I have a table that will be appended to each month with new monthly billing
data from one of my vendors. I have a query that I would like to run that
would show me Country of call (group by), Duration (sum), and Call Date.
What I would like is to be able to change the date range of the query so I
could see the sum of calls for Bolivia in July. I am running on 2007 and I
am a novice to the Access world.

Thanks for the help in advance!
-EW
 
I assume you have a working query.


Change its actual starting and ending date defining the date range with

[Starting Date:]

and

[Ending Date:]

respectively. Run the query. You should now be prompted twice, once to
supply the starting date, once to supply the ending date.

(note: you may make a copy of your working query and modify the copy, not
the original query, so, if something goes wrong, you don't lose your working
query, just the modified query).

Vanderghast, Access MVP
 
Back
Top