crosstab query

A

anil

hi all
I am importing results in excel sheel from website.
In their database they are using crosstab queries for the results and
then exporting them in excel or csv file format on their website.

Now when i import that data in table of access 2000 I am getting in
crosstab format in table like

REF-PROJECTDESCRIPTION-SAMPLEDATE-SITEDESC-ALKALINITY-AMMONIA-BOD(+
many more.)

All these alkalinity ,ammonia,Bod etc are parameters in my database.Is
there any way to convert them back into parameters thus getting results
as normat select query not in crosstab format.
thanks
anil
 
D

Duane Hookom

If I understand correctly, you can use a union query to normalize your
"spreadsheet".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

group to combine parameters 2
group to combine parameters 5
Crosstab query as data source for update query 7
Date Sorting in Crosstab 3
Multiple Parameter Crosstab query filter by form 1
crosstab query parameters 5
crosstab query parameter error 12
Include empty values in crosstab query 5

Top