sorting & grouping?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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



"(e-mail address removed)"
 
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.
Click to expand...

Assuming you have a real data field:

Sort on the data field; group by month.

Information ABC and E will be in the data areas

Information D and F can include subtotals from ABC and E respectively
(group footers)

Is that what you were looking for?
 
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



"(e-mail address removed)"
 
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!!!
 
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!!!
Click to expand...

I am not at all sure how you are going to do the anytime in the month
entry. Maybe you could have two fields one with just the month and a second
field for the date. For all those that had an entry in the month then the
last day of the month could be added to the date field. Then sorting first
on the date field then on the "month only" field you would get the sort
order you want.

Kind of messy, but I think it would work.

Please remember those dates need to be real time-dates types not text.
 
Back
Top