RE: Need help with a query
- From: Sproul <Sproul@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 13 Mar 2006 03:46:27 -0800
thanks for the reply, but i don't know how to write the criteria to set the
count to ZERO if a yes appears in the column.
come to think of it i don't think that you can use an if statement in a
Query in Access 2003.
Item 1 No
Item 2 No
Item 1 No
Item 3 No
Item 2 Yes
Item 2 No
Item 4 Yes
Item 1 No
Item 3 No
A count statement for above would read
Item 1 3
Item 2 2
Item 3 2
Item 4 1
I would like to reset the count to 0 (ZERO) when a yes is found, which would
return
Item 1 3
Item 2 1
Item 3 2
Item 4 0
Is this possible for a query.
P.S. SQL would be easier.
Al....
"Deborah Jean" wrote:
In the Query design window type both criteria on the AND row. In other word.
on the same line even if you have to include the field twice.
"Sproul" wrote:
I've been using Access 2003 for about a year now but would still consider
myself a new user.
I'm having a problem trying to create a query, if indeed the query is
possible to create.
I want to be able to create a count for individual item i.e. there could be
15 instances if one item 10 of another and so on, however i only want it to
count the instance if a certain field = NO, (here comes the hard part) if the
filed with no is YES i want it to reset the count for that item to ZERO.
the database has and incremantal ID field for each record and also a
Timestamp field which i've renamed TSinfo for obvious reasons.
Can anyone give me a few pointers?
Al....
- Follow-Ups:
- Re: Need help with a query
- From: Douglas J Steele
- Re: Need help with a query
- Prev by Date: Weekly calculations in a daily completed form.
- Next by Date: Re: Performing math in VB from an Access Form
- Previous by thread: Weekly calculations in a daily completed form.
- Next by thread: Re: Need help with a query
- Index(es):
Relevant Pages
|
