INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Dcount issues

Dcount issues

(OP)

Hi all,

Thanks for a great forum! smile

I have a report which has a Data source PerformanceIndicators.

And I am using a DCount statement to pull information from another query EnCasesAll.

This is done in the Report DcPerformanceIndicatorsMonthlySummary

The queries run from the same between dates inputted on the form MainScreen. Between [Forms]![MainScreen].[txtStartDate] And [Forms]![MainScreen].[txtEndDate]

I have a Report Header with the breakdown for all data between dates.

I have another Header based on the Validation Date sorted by Month

The problem comes in when I use the DCount within the month header, the numbers are exactly the same as the Report Header for The Enforcements Section.

How do I split the DCount statement amongst the months??

Thanks for all your forthcoming help smile


Thank you,

Kind regards

Triacona

RE: Dcount issues

It sounds like you have no criteria for the DCount. Try DCount("Field Counted", "source query name", "month = " & month). If the month is stored as a string the last part will be "month = '" & month & " ' " (spaces added for clarity).

RE: Dcount issues

I would create a totals query by month that is similar to your dcount(). Then create a small sub-report based on the totals query. Add the sub-report to the month header and set the link master child to the month fields.

Duane
Hook'D on Access
MS Access MVP

RE: Dcount issues

(OP)
Thanks for all the replies !!! bigsmile
I will try implement them as soon as possible and give feedback.

Thank you,

Kind regards

Triacona

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close