sorting & grouping?

B

bob21

i need to organize dates in my database. i would like the end results to
look like the following in a report:
information on A - oct 10, 2005
information on B - oct 12, 2005
information on C - oct 17, 2005
information on D - month of oct 2005
information on E - nov 7, 2005
information on F - month of nov 2005
in essence, i am trying to group or sort my database so that i can see
issues in october with specific dates followed by issues for the month of
october before i begin to see the issues from november/etc. all help greatly
appreciated by this novice!!! many thanks.
 
R

Rick B

A date field stores a specific date. What are you using in your "month of
oct" entries for the date field? Or is this simply an unedited text field?
If you have a date field in access, it must store an actual date (including
a day).

--
Rick B



"[email protected]"
 
B

bob21

at this point the "month of oct" entries would be entered into an unedited
text field.
 
R

Rick B

Not really sure how you will do this. An entry of "Jan 01..." is going to
be listed just prior to "Jun..." because you will be sorting alphabetically
on a text field. Access will have no idea that January entries should come
first, then February, then March, etc.

You can't really use the "LEFT" or "MID" function to get the month in those
generic entries unless you use some big "if" statement.

I guess you'd have to say "If the fourth character is NOT a space, then grab
characters 10, 11, and 12" which will be your generic entry month. If the
fourth character is a space, then you will have an actual date. I guess you
could use a function to convert the string to a date (which can be sorted).

I'm at a loss as to how you will do this. I have never entered a date into
a text field. I use real dates.

Maybe one of the MVPs will have some advise for you.

--
Rick B



"[email protected]"
 
B

bob21

actually information in D & F are just entries without a specific date - they
could be anytime in Oct or any time in Nov respectively. each entry
a,b,c,d,e,f, etc are all specific and i would like to group them by oct dates
that i know followed by entries that could take place any time in oct - then
follow that by nov dates that i know, followed by entries that could take
place any time in nov, etc. thanks!!!
 
Top