How Can I Create This Query

[djclntn]

I a query containing 3-text fields & 5-number fields which are ALL SumOf… In my 1-text field I have it as the months (Feb). My query looks something like:



Months Text-A Text-B SumOf-Z SumOf-X SumOf-Y etc…

I’m trying to create another query that shows me ALL of the Sums based upon certain months.

First thing, in Query Design & the “Month” grid I already know that you need to check off the show box.

I’ve tried ALL of criteria’s which won’t work. In the “Month” grid I tried:
1. = “Oct” =”Nov” =”Dec”
2. Between “Oct” And “Dec”
3. =>"Oct" And <"Dec"

*As you may see I’m trying to retrieve the Sums of Oct thru Dec & I’m having no luck.

Any assistance would be appreciated!

[pbaldy]

Because you have alphabetic months, I doubt Between or the >= tests will work. You see them as months but Access sees them as text values. You probably want to switch to numeric values 1-12. In any case, the first would probably work if you did:

In(“Oct”, ”Nov”, ”Dec”)

[djclntn]

Ok, I added anotherfield to my table with the month in numbers. when i triedrunning a query trying to retrie the sums of certain months I have no luck.

I tried these following criteria's:

1. ="10;" ="11;" ="12"
2. Between "10" And "12"
3. Between 10 And 12
4. => 10 And <1

...?

[pbaldy]

1 is incorrect syntax, you'd need OR or the IN clause I showed before. If your values are numbers, 2 wouldn't work because you've enclosed the values in quotes. I would expect 3 to work, so perhaps you can post the full SQL or a sample db. 4 wouldn't work because no number is both greater than 10 and less than 1.