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
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