Acces Crosstab Query

L

Luis

I need some help:

This is my first time posting questions. I hope I do
this right.

I have created a crosstab query that looks like this:
Code Group Preferred Cost Eckerd Walgreens AVC
h305 Y 305 305 308 310
h456 N 306 308 306 356

I would like to add a condition in which if Group=Y, then
preferred cost should be chosen from Eckerd regardless
whether Eckerd has the lowest or not. Can it be done in
a crosstab query?

Please help.

Luis
 
T

Tony D'Ambra

I think maybe you should use a second query based on the crosstab query, and
add a column:

Preferred: IIf([Group]<>"Y",[Preferred Cost],[Eckerd])


Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net
 
L

Luis

-----Original Message-----
I think maybe you should use a second query based on the crosstab query, and
add a column:

Preferred: IIf([Group]<>"Y",[Preferred Cost],[Eckerd])


Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net

I need some help:

This is my first time posting questions. I hope I do
this right.

I have created a crosstab query that looks like this:
Code Group Preferred Cost Eckerd Walgreens AVC
h305 Y 305 305 308 310
h456 N 306 308 306 356

I would like to add a condition in which if Group=Y, then
preferred cost should be chosen from Eckerd regardless
whether Eckerd has the lowest or not. Can it be done in
a crosstab query?

Please help.

Luis
Click to expand...


.
Thank you Tony. It worked...
Click to expand...

Luis
 
G

Guest

Thank you...It worked :)
-----Original Message-----
I think maybe you should use a second query based on the crosstab query, and
add a column:

Preferred: IIf([Group]<>"Y",[Preferred Cost],[Eckerd])


Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net

I need some help:

This is my first time posting questions. I hope I do
this right.

I have created a crosstab query that looks like this:
Code Group Preferred Cost Eckerd Walgreens AVC
h305 Y 305 305 308 310
h456 N 306 308 306 356

I would like to add a condition in which if Group=Y, then
preferred cost should be chosen from Eckerd regardless
whether Eckerd has the lowest or not. Can it be done in
a crosstab query?

Please help.

Luis
Click to expand...


.
Click to expand...
 
Top