Sorting month problems using comboboxes

  • Thread starter Thread starter Elizabeth
  • Start date Start date
E

Elizabeth

I have a problem that probably has a very simple
solution. I posted this to the "query" newsgroup also.

I have a look-up list (combobox) for Month, which is based
on a fiscal year. The data in the list looks like this:

Col 1 Col2
1 July
2 August
3 September
etc.

I can get it to sort by month number, displaying the name
in text in a QUERY. However, when I try to create a
report based on the query, it lists the months in
alphabetical order, NOT the way it was displayed in the
query. I have tried to change the bound column number, I
feel like I have tried everything. Could someone respond
with an easy solution (if there is one) soon?

Thank you so much!

Elizabeth
 
What do you have set up in the sorting and grouping of
your report? Reports look at this and not to the query
for the ordering of info in your report.
;-)
 
Make sure your data source for your report has the month
number as well as the month description. Then, in the
sorting and grouping options, you should be able to sort
ascending by month number, while grouping by Month
Description (I'm guessing that's what you're doing).
Just make sure the month number preceeds the month
description on the sorting list.

Hope that helps!

;-) Ronda
-----Original Message-----
I am grouping Fiscal Year, Month, and totals by Court
Names.

-----Original Message-----
What do you have set up in the sorting and grouping of
your report? Reports look at this and not to the query
for the ordering of info in your report.
;-)
-----Original Message-----
I have a problem that probably has a very simple
solution. I posted this to the "query" newsgroup also.

I have a look-up list (combobox) for Month, which is based
Click to expand...
Click to expand...
Click to expand...
 
Thanks, I'll try it!
-----Original Message-----
Make sure your data source for your report has the month
number as well as the month description. Then, in the
sorting and grouping options, you should be able to sort
ascending by month number, while grouping by Month
Description (I'm guessing that's what you're doing).
Just make sure the month number preceeds the month
description on the sorting list.

Hope that helps!

;-) Ronda
-----Original Message-----
I am grouping Fiscal Year, Month, and totals by Court
Names.
Click to expand...
Click to expand...
 
Unfortunately, this is still not working. WHen you
say "data source" what are you referring to? Do you mean
use two separate variables or one lookup list? I am very
confused--not by you, just in general. Then my boss just
came by and said, "I thought you knew all about
databases. Isn't that why I hired you?" No, actually. I
know some, but more about statistics!

Sorry. Any help would be great!
-----Original Message-----
Make sure your data source for your report has the month
number as well as the month description. Then, in the
sorting and grouping options, you should be able to sort
ascending by month number, while grouping by Month
Description (I'm guessing that's what you're doing).
Just make sure the month number preceeds the month
description on the sorting list.

Hope that helps!

;-) Ronda
-----Original Message-----
I am grouping Fiscal Year, Month, and totals by Court
Names.
Click to expand...
Click to expand...
 
Back
Top