Report / Query sums

[WorkRelated]

Please help. At the moment I have a query linked to a report that show the
[nett balue] [start date] and [end date] of a job. The purpose of my data
base account based.
To find out the value of jobs that we invoice in amonth I have run a report
that show all the jobs with an end date in between two dates.
To find out what jobs we will be invoiced for I have run a report that shows
all the jobs that have a start date between two dates.
What I want now is to combine the two reports which i have managed by
setting the parameters of the start and end date in the query. The only
problem I am having is getting the total in the report to only total the jobs
that have ended in a certain month. I am pretty basic with Access and I am
finding this hard to do so I am able to run this report for any month at any
time. Maybe it is the way I have set up the query I am not sure. Please help

 

[golfinray]

You could try the Between command. Between 1/1/2009 and 2/1/2009 in the query
criteria.

 

[Douglas J. Steele]

<picky>

Between #1/1/2009# and #2/1/2009#

</picky>

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

You could try the Between command. Between 1/1/2009 and 2/1/2009 in the
query
criteria.
--
Milton Purdy
ACCESS
State of Arkansas

Please help. At the moment I have a query linked to a report that show
the
[nett balue] [start date] and [end date] of a job. The purpose of my data
base account based.
To find out the value of jobs that we invoice in amonth I have run a
report
that show all the jobs with an end date in between two dates.
To find out what jobs we will be invoiced for I have run a report that
shows
all the jobs that have a start date between two dates.
What I want now is to combine the two reports which i have managed by
setting the parameters of the start and end date in the query. The only
problem I am having is getting the total in the report to only total the
jobs
that have ended in a certain month. I am pretty basic with Access and I
am
finding this hard to do so I am able to run this report for any month at
any
time. Maybe it is the way I have set up the query I am not sure. Please
help