Referencing Crosstab Query Values

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi All,

Does anyone know how to programmatically reference crosstab query results?
I'm trying to get them into a form that is bound to a table but am not
having luck.

Thanks & Ciao,

Tony
 
You might need to provide more details. I don't have a clue what you mean by
"get them into a form". Does your crosstab have static column headings?
 
Hi Duane,

Thanks for the response, but I think I solved my issue last night. Here's
the setup I had:

I ran a select query to pull together some rates (from a rates table) and
some hours (Straight, Overtime, & Doubletime from a records table) and added
calculated fields to find the product (charge). I then ran a crosstab query
to get the sum of all the charges for records that met a particular
criteria. Then, I was trying to get the values from the crosstab into a
form so that I do some comparison between the database data and matching
data from an external source (variance). The form I was trying to get the
crosstab values into was bound to a table so that I could store some
information.

After working on this a while, ended up leaving the form bound to the table,
and set the values of the controls to the Sum of the charges from the
original select query. This works well and eliminates (as far as I can
tell) the need for the crosstab query and I'm plowing ahead with it. I
think I was just hung up on using the crosstab since it was the first time I
worked with one and was determined to make it work.

BTW, the columns were not fixed. If you can think of a better solution,
please let me know. Simpler is better, and at this point I'm unsure if I've
made it simple enough. If you want me to post additional information,
please let me know.

Thanks,

Tony
 
If you have more questions, please post them. I am getting old an lost track
of your explaination about 2 sentences into the first paragraph. I generally
like to know:
where you are starting from ie: the tables and data
where you want to go including data results and display
If you start telling me "I went here, then turned here and then went there",
I just get lost and confused.
 
Duane,

Thanks for the response. No more questions; I went back to square one and
restructured the tables & relationships and got things working.

Thanks for the assistance,

Tony
 
Back
Top