Using the values of a crosstab query to create new values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I hope someone can help me. I have a simple query in which I''ve set
parameters to search for an individual id, beginning, and end date. I then
created a crosstab query which pulls a one line listing of values for date
range and individual. This works great. Here's the problem. I now need to
take the values from the crosstab query to create additional values. i.e
code_1:Int(([1]/Total Of code])*100) , code_2...... , code_3....... .
Before I set the parameter in the original query for the date range and
individual I was able to create a new simple query and pull the crosstab
values in along with the new fields I need. Since setting the parameters
when I go to create a simple query based on the crosstable query there are
no columns to select. I assume this is due to the parameters. I'm struggle
with how to resolve this problem. Any help is greatly appreciated. Thanks
a lot.

Becky
 
Back
Top