Sort based on data from 6 fields

[Guest]

I have fields named monday - Saturday e.g. [Monday] [Tuesday] etc. I also
have fields called [Mon-Sort], [Tue-Sort] etc. if monday is chosen then i
want it to sort by the [Mon-Sort] field, if Tuesday is chosen I want it to
sort by The [Tue-Sort] field and so on. My problem is coming up with a
variable to choose which sort field to sort on. Help!

 

[Duane Hookom]

Sounds fairly un-normalized....

What is the data type of the "sort" fields? Can only one "sort" field be
selected? ie: can Mon-Sort and Tue-Sort both be "chosen"? What do you mean
by "chosen"?

 

[Guest]

The sort field is a number field. I'm trying to print out quote sheets for
customers. I want to be able to print out a sheet for the same customer on
Monday that is sorted different on Thursday. I can only have 1 sort field
sorting at a time.

Sounds fairly un-normalized....

What is the data type of the "sort" fields? Can only one "sort" field be
selected? ie: can Mon-Sort and Tue-Sort both be "chosen"? What do you mean
by "chosen"?

--
Duane Hookom
MS Access MVP
--

I have fields named monday - Saturday e.g. [Monday] [Tuesday] etc. I also
have fields called [Mon-Sort], [Tue-Sort] etc. if monday is chosen then i
want it to sort by the [Mon-Sort] field, if Tuesday is chosen I want it to
sort by The [Tue-Sort] field and so on. My problem is coming up with a
variable to choose which sort field to sort on. Help!

 

[Duane Hookom]

What do you mean by "if Tuesday is chosen"? Are you asking how to "choose" a
field to sort by or do you already have a value in a table that can be used?

Did you understand my comments about being un-normalized?

--
Duane Hookom
MS Access MVP
--

The sort field is a number field. I'm trying to print out quote sheets
for
customers. I want to be able to print out a sheet for the same customer
on
Monday that is sorted different on Thursday. I can only have 1 sort field
sorting at a time.

Sounds fairly un-normalized....

What is the data type of the "sort" fields? Can only one "sort" field be
selected? ie: can Mon-Sort and Tue-Sort both be "chosen"? What do you
mean
by "chosen"?

--
Duane Hookom
MS Access MVP
--

I have fields named monday - Saturday e.g. [Monday] [Tuesday] etc. I
also
have fields called [Mon-Sort], [Tue-Sort] etc. if monday is chosen then
i
want it to sort by the [Mon-Sort] field, if Tuesday is chosen I want it
to
sort by The [Tue-Sort] field and so on. My problem is coming up with a
variable to choose which sort field to sort on. Help!

 

[Guest]

if i choose the field [Tuesday] the records are queryed by the [Tuesday]
Field then i want it to sort on the [Tue-Sort] field. when [Monday] is
chosen the records are queryed on [Monday] field and i want to sort it by
[Mon-Sort] field.

No i didn't understand your un-normalized comment

What do you mean by "if Tuesday is chosen"? Are you asking how to "choose" a
field to sort by or do you already have a value in a table that can be used?

Did you understand my comments about being un-normalized?

--
Duane Hookom
MS Access MVP
--

The sort field is a number field. I'm trying to print out quote sheets
for
customers. I want to be able to print out a sheet for the same customer
on
Monday that is sorted different on Thursday. I can only have 1 sort field
sorting at a time.

Sounds fairly un-normalized....

What is the data type of the "sort" fields? Can only one "sort" field be
selected? ie: can Mon-Sort and Tue-Sort both be "chosen"? What do you
mean
by "chosen"?

--
Duane Hookom
MS Access MVP
--

I have fields named monday - Saturday e.g. [Monday] [Tuesday] etc. I
also
have fields called [Mon-Sort], [Tue-Sort] etc. if monday is chosen then
i
want it to sort by the [Mon-Sort] field, if Tuesday is chosen I want it
to
sort by The [Tue-Sort] field and so on. My problem is coming up with a
variable to choose which sort field to sort on. Help!

 

[Duane Hookom]

Bill,
How do you choose the field [Tuesday]? I'm have great difficulty
understanding your tables, actions, and desires. Perhaps you should provide
some sample records, your actions, and how you would expect to see the
records display.

There are some good links regarding normalizing tables at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101.

--
Duane Hookom
MS Access MVP
--

if i choose the field [Tuesday] the records are queryed by the [Tuesday]
Field then i want it to sort on the [Tue-Sort] field. when [Monday] is
chosen the records are queryed on [Monday] field and i want to sort it by
[Mon-Sort] field.

No i didn't understand your un-normalized comment

What do you mean by "if Tuesday is chosen"? Are you asking how to
"choose" a
field to sort by or do you already have a value in a table that can be
used?

Did you understand my comments about being un-normalized?

--
Duane Hookom
MS Access MVP
--

The sort field is a number field. I'm trying to print out quote sheets
for
customers. I want to be able to print out a sheet for the same
customer
on
Monday that is sorted different on Thursday. I can only have 1 sort
field
sorting at a time.

:

Sounds fairly un-normalized....

What is the data type of the "sort" fields? Can only one "sort" field
be
selected? ie: can Mon-Sort and Tue-Sort both be "chosen"? What do you
mean
by "chosen"?

--
Duane Hookom
MS Access MVP
--

I have fields named monday - Saturday e.g. [Monday] [Tuesday] etc. I
also
have fields called [Mon-Sort], [Tue-Sort] etc. if monday is chosen
then
i
want it to sort by the [Mon-Sort] field, if Tuesday is chosen I want
it
to
sort by The [Tue-Sort] field and so on. My problem is coming up
with a
variable to choose which sort field to sort on. Help!

 

[Guest]

Duane;

Thanks for your help. I did discover how i can select an individual field
to sort my data for the report

Thanks Bill

Bill,
How do you choose the field [Tuesday]? I'm have great difficulty
understanding your tables, actions, and desires. Perhaps you should provide
some sample records, your actions, and how you would expect to see the
records display.

There are some good links regarding normalizing tables at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101.

--
Duane Hookom
MS Access MVP
--

if i choose the field [Tuesday] the records are queryed by the [Tuesday]
Field then i want it to sort on the [Tue-Sort] field. when [Monday] is
chosen the records are queryed on [Monday] field and i want to sort it by
[Mon-Sort] field.

No i didn't understand your un-normalized comment

What do you mean by "if Tuesday is chosen"? Are you asking how to
"choose" a
field to sort by or do you already have a value in a table that can be
used?

Did you understand my comments about being un-normalized?

--
Duane Hookom
MS Access MVP
--

The sort field is a number field. I'm trying to print out quote sheets
for
customers. I want to be able to print out a sheet for the same
customer
on
Monday that is sorted different on Thursday. I can only have 1 sort
field
sorting at a time.

:

Sounds fairly un-normalized....

What is the data type of the "sort" fields? Can only one "sort" field
be
selected? ie: can Mon-Sort and Tue-Sort both be "chosen"? What do you
mean
by "chosen"?

--
Duane Hookom
MS Access MVP
--

I have fields named monday - Saturday e.g. [Monday] [Tuesday] etc. I
also
have fields called [Mon-Sort], [Tue-Sort] etc. if monday is chosen
then
i
want it to sort by the [Mon-Sort] field, if Tuesday is chosen I want
it
to
sort by The [Tue-Sort] field and so on. My problem is coming up
with a
variable to choose which sort field to sort on. Help!