Acces Crosstab Query

[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

 

[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

 

[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

.
Thank you Tony. It worked...

Luis

 

[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

.