• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

unbound control on form show count of certain items

I have a form that shows number of claims.  The users want, at the bottom of the form, controls that reflect the count of claim for the prior month and then a count of claim for MTD.  Since these are unaboug, I tried making a select query as the source for one of the count control, but it did not work.  So. how can I get two controls to count items in the underlying table based on different critieria?  The counts are separate from the individual detail data as reflected on the form, which shows only the detail for one clailm record at a time.  This is an ACCESS 2003 database.

SELECT TblClaims.ClaimACHATM, TblClaims.ClaimMonth, TblClaims.ClaimYear, Count(TblClaims.ClaimDateReceived) AS CountOfClaimDateReceived
FROM TblClaims
GROUP BY TblClaims.ClaimACHATM, TblClaims.ClaimMonth, TblClaims.ClaimYear
HAVING (((TblClaims.ClaimACHATM)="ACH") AND ((TblClaims.ClaimMonth)=Month(Date())) AND ((TblClaims.ClaimYear)=Year(Date())));

Open in new window

0
ssmith94015
Asked:
ssmith94015
  • 5
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
have tried using the dcount() function?
   dCount(expr, domain, [criteria])
0
 
ssmith94015Author Commented:
Let me try that, I was just wondering about the multiple criteria.  Be right back.
0
 
ssmith94015Author Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for ssmith94015's comment http:/Q_27409359.html#37008318

for the following reason:

Next issue will be to adjust for DEC/JAN, but I wil work on that for a bit yet. &nbsp;thank you for the answer.<br /><br />Sandra
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Rey Obrero (Capricorn1)Commented:
what ?
0
 
ssmith94015Author Commented:
OK, I messed up adn hit the wrong button.  Let me get assistance, sorry about that!
0
 
ssmith94015Author Commented:
Capricon should get the points, I hit the wrong button when closing the questions.
0
 
ssmith94015Author Commented:
Ok, I think this will assgin the points now.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now