crosstab query

  • Thread starter Thread starter anil
  • Start date Start date
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
 
If I understand correctly, you can use a union query to normalize your
"spreadsheet".
 
Back
Top