Add a field to the results of a crosstab

[goldenvision]

Is it possible to create a crosstab table and then add an extra field which can be amended to specify whether the record can or cannot be printed?

 

[gblack]

Ya

Sure…you mean a crosstab query right? You can either base the crosstab query off of another query, or you can create a new field in the crosstab query based in the values in it.

What is your process and what is the value that will tell you if the record should be printed?

 

[goldenvision]

Can I email you the database. It is probably easier to look at it rather than me try to explain it.

The criteria for whether the record is to be printed or not will be if there is an "A" in the last comp field of the Payout_Crostab query.

 

[gblack]

Ok

You'll probably have to take out everything but what you are working on and zip it. I have hotmail, so the file has to be super small. I'm off in about 20 min. So make it fast, or I wont be able to respond until tomorrow. You might wanna cut the table down a bit too...dunno.

I'll post the solution to the site so no one gets worked up about "free tech support" or whatever.

gblackiv@hotmail.com