I'm using Access 2003. I have a query that holds site ids, chemicals and the chemical's BSAF:
I need to dynamically create a table based off this query that adds the chemical as a field so the table would end
up being like:
Is there a good way to handle this?
Thanks
James
Code:
SiteID Chemical BSAF
1 Chem1 .0001
1 Chem2 .0002
up being like:
Code:
SiteID Chem1 Chem 2
1 .0001 .0002
Is there a good way to handle this?
Thanks
James