Date/Text problem

[Guest]

hi, newbie here trying to create a report that i can sort by date field [date
expected] and then ultimately by a text field [date expected text] - i would
like to see the report read as:
jan 23
jan 24
jan 25
JAN - 06
feb 12
feb 17
feb 20
FEB - 06
any help very much appreciated.

 

[Duane Hookom]

How about providing some actual records showing both fields? Then show how
these exact records should appear in your report.

 

[Guest]

Table #1
ID Week of Action DateIndexing Number
1 09-Jan-06 09-Jan 1
2 09-Jan-06 10-Jan 1
3 09-Jan-06 11-Jan 1
4 09-Jan-06 12-Jan 1
5 09-Jan-06 13-Jan 1
6 16-Jan-06 16-Jan 2
7 16-Jan-06 17-Jan 2
8 16-Jan-06 18-Jan 2
9 16-Jan-06 19-Jan 2
Table #2
Time FrameTF Numeric
Oct 05 1
Nov 05 2
Dec 05 3
Q4 2005 4
Jan 06 5
Feb 06 6
Mar 06 7
Q1 2006 8
Apr 06 9
May 06 10
Jun 06 11
Q2 2006 12
1st Half 2006 13

there are two separate tables above - the first has ID which is the KEY and
then i link the days of the week with the date of that monday for that week.
i thought maybe i could combine the two tables later on by using some
indexing number in table 1 with a TF numeric number in table 2 - before i
screwed up my whole database - i figured i better check with the experts.
does this sound right or is there a better/easier way to go about it. thanks.

How about providing some actual records showing both fields? Then show how
these exact records should appear in your report.

--
Duane Hookom
MS Access MVP
--

"(e-mail address removed)"

hi, newbie here trying to create a report that i can sort by date field
[date
expected] and then ultimately by a text field [date expected text] - i
would
like to see the report read as:
jan 23
jan 24
jan 25
JAN - 06
feb 12
feb 17
feb 20
FEB - 06
any help very much appreciated.

 

[Duane Hookom]

I have no idea what you have and what you are attempting to do. I can't tell
where your field names start and end since you seem to have embedded spaces
in field names.

You shouldn't be storing date values in text fields.

--
Duane Hookom
MS Access MVP
--

"(e-mail address removed)"

Table #1
ID Week of Action DateIndexing Number
1 09-Jan-06 09-Jan 1
2 09-Jan-06 10-Jan 1
3 09-Jan-06 11-Jan 1
4 09-Jan-06 12-Jan 1
5 09-Jan-06 13-Jan 1
6 16-Jan-06 16-Jan 2
7 16-Jan-06 17-Jan 2
8 16-Jan-06 18-Jan 2
9 16-Jan-06 19-Jan 2
Table #2
Time FrameTF Numeric
Oct 05 1
Nov 05 2
Dec 05 3
Q4 2005 4
Jan 06 5
Feb 06 6
Mar 06 7
Q1 2006 8
Apr 06 9
May 06 10
Jun 06 11
Q2 2006 12
1st Half 2006 13

there are two separate tables above - the first has ID which is the KEY
and
then i link the days of the week with the date of that monday for that
week.
i thought maybe i could combine the two tables later on by using some
indexing number in table 1 with a TF numeric number in table 2 - before i
screwed up my whole database - i figured i better check with the experts.
does this sound right or is there a better/easier way to go about it.
thanks.

How about providing some actual records showing both fields? Then show
how
these exact records should appear in your report.

--
Duane Hookom
MS Access MVP
--

"(e-mail address removed)"

hi, newbie here trying to create a report that i can sort by date field
[date
expected] and then ultimately by a text field [date expected text] - i
would
like to see the report read as:
jan 23
jan 24
jan 25
JAN - 06
feb 12
feb 17
feb 20
FEB - 06
any help very much appreciated.