Reference Field

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

Guest

I am using Access Database 97. In my database I have a Reference Field, the
reference is entered as a month and record number EG: April 01, April, 02,
May 01 etc. I have a seprate date field which puts the date in
automatically. I have to run a report each year, which I use the date field.
When the report is run off it puts the reference field in alpherbetic order.
Is their any way that I can get it to put it in month order EG: jan, feb
march etc
 
Why are you putting the month in the "ref" field if you already have a date
field? That seems redundant. You could jump through hoops to turn the
first three characters of your Ref field into a numeric month, but why? You
already have a month in your date field.


To sort by the month in your actual date field, just put something like the
following in your sorting and grouping box...

=Format([YourDateFieldNameHere], "YYYYMM"

Your secondary sort could then pull the right two digits from your Ref
field...

=Right([Reference],2)
 
Please note that I forgot the closing parenthesis in that first statement.
It should be...

=Format([YourDateFieldNameHere], "YYYYMM")


--
Rick B



Rick B said:
Why are you putting the month in the "ref" field if you already have a
date field? That seems redundant. You could jump through hoops to turn
the first three characters of your Ref field into a numeric month, but
why? You already have a month in your date field.


To sort by the month in your actual date field, just put something like
the following in your sorting and grouping box...

=Format([YourDateFieldNameHere], "YYYYMM"

Your secondary sort could then pull the right two digits from your Ref
field...

=Right([Reference],2)



--
Rick B



horseman said:
I am using Access Database 97. In my database I have a Reference Field,
the
reference is entered as a month and record number EG: April 01, April,
02,
May 01 etc. I have a seprate date field which puts the date in
automatically. I have to run a report each year, which I use the date
field.
When the report is run off it puts the reference field in alpherbetic
order.
Is their any way that I can get it to put it in month order EG: jan, feb
march etc
Click to expand...
Click to expand...
 
Thanks for that. If I got rid of my reference field and used the date field,
I still need to number my records for each month eg: April 01, April 02, May
01, May 02 etc. Would I have to put in a number field? and how would I run
my report to pick up the date field and number for the year.

Rick B said:
Please note that I forgot the closing parenthesis in that first statement.
It should be...

=Format([YourDateFieldNameHere], "YYYYMM")


--
Rick B



Rick B said:
Why are you putting the month in the "ref" field if you already have a
date field? That seems redundant. You could jump through hoops to turn
the first three characters of your Ref field into a numeric month, but
why? You already have a month in your date field.


To sort by the month in your actual date field, just put something like
the following in your sorting and grouping box...

=Format([YourDateFieldNameHere], "YYYYMM"

Your secondary sort could then pull the right two digits from your Ref
field...

=Right([Reference],2)



--
Rick B



horseman said:
I am using Access Database 97. In my database I have a Reference Field,
the
reference is entered as a month and record number EG: April 01, April,
02,
May 01 etc. I have a seprate date field which puts the date in
automatically. I have to run a report each year, which I use the date
field.
When the report is run off it puts the reference field in alpherbetic
order.
Is their any way that I can get it to put it in month order EG: jan, feb
march etc
Click to expand...
Click to expand...
Click to expand...
 
Back
Top