Weekly Score

[lilbit27]

I have a calendar where the user picks a range of dates to see a
weekly or monthly score. However I don't want the dates to show
because it spikes out the scores for each day. If a user has 12 items
that were qa'd during the week of 7//16 and 7/20. I want to be able to
pick those dates on the calendar but for the report to say 12 and
score

not 7/16 2 95% 7/17 3 100% 7/18 2 88% 7/19 4 72% and 7/20 1 100%

my code says :


DoCmd.OpenReport "RWeeklySummary", acViewPreview, , "[DateQA] between
#" & Me.txtbegindate & "# and #" & Me.txtenddate & "#"

The problem is I don't want the DateQA to show. How do I remove it and
still allow them to select the weekly range

 

[Guest]

Base your report off a Totals Query. Use date fields from a form (you can
use the calendar feature) as criteria in your query. For the Totals do a
Count in the Item field and a Where under the date field.

Hope this helps

 

[lilbit27]

Base your report off a Totals Query. Use date fields from a form (you can
use the calendar feature) as criteria in your query. For the Totals do a
Count in the Item field and a Where under the date field.

Hope this helps

I have a calendar where the user picks a range of dates to see a
weekly or monthly score. However I don't want the dates to show
because it spikes out the scores for each day. If a user has 12 items
that were qa'd during the week of 7//16 and 7/20. I want to be able to
pick those dates on the calendar but for the report to say 12 and
score

not 7/16 2 95% 7/17 3 100% 7/18 2 88% 7/19 4 72% and 7/20 1 100%

my code says :

DoCmd.OpenReport "RWeeklySummary", acViewPreview, , "[DateQA] between
#" & Me.txtbegindate & "# and #" & Me.txtenddate & "#"

The problem is I don't want the DateQA to show. How do I remove it and
still allow them to select the weekly range- Hide quoted text -

- Show quoted text -

The problem that I am having is how to use the calendar criteria in my
query.

 

[Guest]

You need to create fields on a form for Beginning Date and Ending Date. The
fields can be unbound. Be sure to name them (i.e. BegDate and EndDate).

Use the fields in your query criteria for the date field like:
Between Forms!frmFormName!BegDate and Forms!frmFormName!EndDate

In order to test the query, be sure you have tabbed out of the date fields.
If you would like to have the choice of blank date fields meaning "All" then
let us know.

Base your report off a Totals Query. Use date fields from a form (you can
use the calendar feature) as criteria in your query. For the Totals do a
Count in the Item field and a Where under the date field.

Hope this helps

I have a calendar where the user picks a range of dates to see a
weekly or monthly score. However I don't want the dates to show
because it spikes out the scores for each day. If a user has 12 items
that were qa'd during the week of 7//16 and 7/20. I want to be able to
pick those dates on the calendar but for the report to say 12 and
score

not 7/16 2 95% 7/17 3 100% 7/18 2 88% 7/19 4 72% and 7/20 1 100%

my code says :

DoCmd.OpenReport "RWeeklySummary", acViewPreview, , "[DateQA] between
#" & Me.txtbegindate & "# and #" & Me.txtenddate & "#"

The problem is I don't want the DateQA to show. How do I remove it and
still allow them to select the weekly range- Hide quoted text -

- Show quoted text -

The problem that I am having is how to use the calendar criteria in my
query.

 

[lilbit27]

You need to create fields on a form for Beginning Date and Ending Date. The
fields can be unbound. Be sure to name them (i.e. BegDate and EndDate).

Use the fields in your query criteria for the date field like:
Between Forms!frmFormName!BegDate and Forms!frmFormName!EndDate

In order to test the query, be sure you have tabbed out of the date fields.
If you would like to have the choice of blank date fields meaning "All" then
let us know.

Base your report off a Totals Query. Use date fields from a form (you can
use the calendar feature) as criteria in your query. For the Totals do a
Count in the Item field and a Where under the date field.
Hope this helps
:
I have a calendar where the user picks a range of dates to see a
weekly or monthly score. However I don't want the dates to show
because it spikes out the scores for each day. If a user has 12 items
that were qa'd during the week of 7//16 and 7/20. I want to be able to
pick those dates on the calendar but for the report to say 12 and
score
not 7/16 2 95% 7/17 3 100% 7/18 2 88% 7/19 4 72% and 7/20 1 100%
my code says :
DoCmd.OpenReport "RWeeklySummary", acViewPreview, , "[DateQA] between
#" & Me.txtbegindate & "# and #" & Me.txtenddate & "#"
The problem is I don't want the DateQA to show. How do I remove it and
still allow them to select the weekly range- Hide quoted text -
- Show quoted text -

The problem that I am having is how to use the calendar criteria in my
query.- Hide quoted text -

- Show quoted text -

The query works but now the report is saying it is to complex to run.

 

[Guest]

Do you have calculated fields on your report? Sometimes that error occurs
when a field type is incorrect or incompatible. Change as many calculations
as possible to your query.

Other than that, I would look at the sorting and grouping or just remove
fields until you find the trigger.

You need to create fields on a form for Beginning Date and Ending Date. The
fields can be unbound. Be sure to name them (i.e. BegDate and EndDate).

Use the fields in your query criteria for the date field like:
Between Forms!frmFormName!BegDate and Forms!frmFormName!EndDate

In order to test the query, be sure you have tabbed out of the date fields.
If you would like to have the choice of blank date fields meaning "All" then
let us know.

On Jul 24, 12:28 pm, Jackie L <[email protected]>
wrote:
Base your report off a Totals Query. Use date fields from a form (you can
use the calendar feature) as criteria in your query. For the Totals do a
Count in the Item field and a Where under the date field.

Hope this helps

:
I have a calendar where the user picks a range of dates to see a
weekly or monthly score. However I don't want the dates to show
because it spikes out the scores for each day. If a user has 12 items
that were qa'd during the week of 7//16 and 7/20. I want to be able to
pick those dates on the calendar but for the report to say 12 and
score

not 7/16 2 95% 7/17 3 100% 7/18 2 88% 7/19 4 72% and 7/20 1 100%

my code says :

DoCmd.OpenReport "RWeeklySummary", acViewPreview, , "[DateQA] between
#" & Me.txtbegindate & "# and #" & Me.txtenddate & "#"

The problem is I don't want the DateQA to show. How do I remove it and
still allow them to select the weekly range- Hide quoted text -

- Show quoted text -
The problem that I am having is how to use the calendar criteria in my
query.- Hide quoted text -

- Show quoted text -

The query works but now the report is saying it is to complex to run.