Dual Date function

[bladelock]

I have a report that is generated by a query.
My Query1 has these fields: fDate, Name, Amt In the Critiera field for
(fDate) I have: Between [Start Date] and [Ending Date].

This all works fine on the report with Sum for Amt at the end of the report.

The data looks like this
fDate Name Amt
01/01/2005 Tom 10.00
01/05/2005 Joe 20.00
01/30/2005 John 30.00
01/30/2005 Frank 30.00

The user only want to print what he entered today which is 01/30/2005
Which he will enters in the Dialog box of dates 01/30/2005 and 01/30/2005
inturn, it prints two names and a total of $60.00. HERE IS THE PROBLEM:

The user want to the total of the whole month of $90.00 but only see what he
input on the dates he entered in the Dialog box.
Is there a way of doing this? I only using simple query and reports functions?
Thanks

 

[Duane Hookom]

So, are you getting rid of one parameter prompt and just prompting for one
date but including all the values for the entire month in the report footer?
Or, are there still two dates entered?

 

[bladelock]

I didn't change anything, there are still two date prompts.

So, are you getting rid of one parameter prompt and just prompting for one
date but including all the values for the entire month in the report footer?
Or, are there still two dates entered?

--
Duane Hookom
MS Access MVP

I have a report that is generated by a query.
My Query1 has these fields: fDate, Name, Amt In the Critiera field for
(fDate) I have: Between [Start Date] and [Ending Date].

This all works fine on the report with Sum for Amt at the end of the
report.

The data looks like this
fDate Name Amt
01/01/2005 Tom 10.00
01/05/2005 Joe 20.00
01/30/2005 John 30.00
01/30/2005 Frank 30.00

The user only want to print what he entered today which is 01/30/2005
Which he will enters in the Dialog box of dates 01/30/2005 and 01/30/2005
inturn, it prints two names and a total of $60.00. HERE IS THE PROBLEM:

The user want to the total of the whole month of $90.00 but only see what
he
input on the dates he entered in the Dialog box.
Is there a way of doing this? I only using simple query and reports
functions?
Thanks

 

[bladelock]

Also, there are other months in the database that I don't want to include.
That's why I prompt for begin and end dates.

So, are you getting rid of one parameter prompt and just prompting for one
date but including all the values for the entire month in the report footer?
Or, are there still two dates entered?

--
Duane Hookom
MS Access MVP

I have a report that is generated by a query.
My Query1 has these fields: fDate, Name, Amt In the Critiera field for
(fDate) I have: Between [Start Date] and [Ending Date].

This all works fine on the report with Sum for Amt at the end of the
report.

The data looks like this
fDate Name Amt
01/01/2005 Tom 10.00
01/05/2005 Joe 20.00
01/30/2005 John 30.00
01/30/2005 Frank 30.00

The user only want to print what he entered today which is 01/30/2005
Which he will enters in the Dialog box of dates 01/30/2005 and 01/30/2005
inturn, it prints two names and a total of $60.00. HERE IS THE PROBLEM:

The user want to the total of the whole month of $90.00 but only see what
he
input on the dates he entered in the Dialog box.
Is there a way of doing this? I only using simple query and reports
functions?
Thanks

 

[jahoobob]

Run two queries. One that gets the days transactions and set th
criteria for fDate to =[Whatdate] and another that extracts the mont
and year from [Whatdate] in the first query and is used to sum up th
month. Make the first query the source of a report and then make a su
report with the second query as the source.

I have a report that is generated by a query.
My Query1 has these fields: fDate, Name, Amt In the Critiera fiel
for
(fDate) I have: Between [Start Date] and [Ending Date].

This all works fine on the report with Sum for Amt at the end of th
report.

The data looks like this
fDate Name Amt
01/01/2005 Tom 10.00
01/05/2005 Joe 20.00
01/30/2005 John 30.00
01/30/2005 Frank 30.00

The user only want to print what he entered today which is 01/30/2005
Which he will enters in the Dialog box of dates 01/30/2005 an
01/30/2005
inturn, it prints two names and a total of $60.00. HERE IS TH
PROBLEM:

The user want to the total of the whole month of $90.00 but only se
what he
input on the dates he entered in the Dialog box.
Is there a way of doing this? I only using simple query and report
functions?
Thank

 

[Duane Hookom]

Could you provide some sample records that span several months and then a
couple start and end dates and what you want to see in a report?

--
Duane Hookom
MS Access MVP

I didn't change anything, there are still two date prompts.

So, are you getting rid of one parameter prompt and just prompting for
one
date but including all the values for the entire month in the report
footer?
Or, are there still two dates entered?

--
Duane Hookom
MS Access MVP

I have a report that is generated by a query.
My Query1 has these fields: fDate, Name, Amt In the Critiera field for
(fDate) I have: Between [Start Date] and [Ending Date].

This all works fine on the report with Sum for Amt at the end of the
report.

The data looks like this
fDate Name Amt
01/01/2005 Tom 10.00
01/05/2005 Joe 20.00
01/30/2005 John 30.00
01/30/2005 Frank 30.00

The user only want to print what he entered today which is 01/30/2005
Which he will enters in the Dialog box of dates 01/30/2005 and
01/30/2005
inturn, it prints two names and a total of $60.00. HERE IS THE PROBLEM:

The user want to the total of the whole month of $90.00 but only see
what
he
input on the dates he entered in the Dialog box.
Is there a way of doing this? I only using simple query and reports
functions?
Thanks