If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query Criteria
I have a query where I am trying to get a count of items. The first column
is: Less than 10: (IIf([Days in Queue]10,"")) This gives a count for each queue that has been under 10 days and is working correctly. I cannot get the criteria to work for the # ranges after that. I want it to return the count for anything that has been in queue for 10 to 20 days. I know what I have below does not work. I need something for the =10-20 part. Right now I get all zeros returned. 10-20: (IIf([Days in Queue]=10-20,"")) Please help! -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Query Criteria
Ladybug -
Try this criteria (this includes the values 10 and 20, so if you really want 10-19, then change the 20 to 19: ([Days in Queue] Between 10 AND 20) -- Daryl S "ladybug via AccessMonster.com" wrote: I have a query where I am trying to get a count of items. The first column is: Less than 10: (IIf([Days in Queue]10,"")) This gives a count for each queue that has been under 10 days and is working correctly. I cannot get the criteria to work for the # ranges after that. I want it to return the count for anything that has been in queue for 10 to 20 days. I know what I have below does not work. I need something for the =10-20 part. Right now I get all zeros returned. 10-20: (IIf([Days in Queue]=10-20,"")) Please help! -- Message posted via http://www.accessmonster.com . |
#3
|
|||
|
|||
Query Criteria
Perfect! Thank you for your helping!
Daryl S wrote: Ladybug - Try this criteria (this includes the values 10 and 20, so if you really want 10-19, then change the 20 to 19: ([Days in Queue] Between 10 AND 20) I have a query where I am trying to get a count of items. The first column is: [quoted text clipped - 9 lines] Please help! -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
Query Criteria
Perfect! Thank you for helping!
Daryl S wrote: Ladybug - Try this criteria (this includes the values 10 and 20, so if you really want 10-19, then change the 20 to 19: ([Days in Queue] Between 10 AND 20) I have a query where I am trying to get a count of items. The first column is: [quoted text clipped - 9 lines] Please help! -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|