How do I set up a begin date & end date and get the information?

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

I work for a non-profit that gives people money for Gas, Rent, ect. My table
is simple; date money was given, Last name, First, personal info, addresses
ect. I also have fields named Gas, Rent, Food. . where the amount given is
input. I want to design a Report where I can put in a beginning date and an
end date and retrive the sum of the amounts given out for each of these
fields (gas, rent, food, ect.) for a time period of my choice. I'm working
with Access 2003. I'm pretty new with Access and have tried everything! My
query will sum the entire table and total it but I need different dates to
get a clear view of how much money is being used. Can anyone help?
 
In query design view in the grid row labeled Criteria: and below your 'date
money was given' field enter this --
Between [Enter start (m/d/yyyy)] And [Enter End (m/d/yyyy)]
 
Then next step is to have a form where the user enters the dates and clicks
a button to run the report.

The query would then refer to the form variables (Forms!myform!txtstartDate)
for example.

Karl had you put criteria in brackets so it prompts for values. Which is a
good first step to understanding.

Mark
KARL DEWEY said:
In query design view in the grid row labeled Criteria: and below your
'date
money was given' field enter this --
Between [Enter start (m/d/yyyy)] And [Enter End (m/d/yyyy)]


CJ said:
I work for a non-profit that gives people money for Gas, Rent, ect. My
table
is simple; date money was given, Last name, First, personal info,
addresses
ect. I also have fields named Gas, Rent, Food. . where the amount given
is
input. I want to design a Report where I can put in a beginning date and
an
end date and retrive the sum of the amounts given out for each of these
fields (gas, rent, food, ect.) for a time period of my choice. I'm
working
with Access 2003. I'm pretty new with Access and have tried everything!
My
query will sum the entire table and total it but I need different dates
to
get a clear view of how much money is being used. Can anyone help?
Click to expand...
Click to expand...
 
CJ, both Karl and Mark are correct. Karl's solution is best for
beginners, and Mark has taken it to the more "professional" level
where you can have a form for the user to type in the dates and hit a
'submit' button to generate the report. This prevents the user from
having to constantly type in dates if you want to re-run the report
several times (perhaps with slightly different data).

Here is a video tutorial I made on how to create the data-entry form
for something like this:

http://599cd.com/tips/access/forms-formname-field-notation/?key=usenet

Hope this helps.


Richard Rost
http://www.AccessLearningZone.com
 
Back
Top