ms access

R

RWMATSE

I have a imported a table containg 12 records per key (1 per given yyyy/mm).
How do I create a query or new table that will give me 1 record per key with
12 columns.

I tried a crosstab query, but it used the value for the fieldname ... the
data will change every month, which means the fieldnames will change also
....not good.

I also tried using the 'captions' option, with "jan", "feb" ..etc. , but
then I get no data because 2008/01 doesn't match "jan" ...

any ideas????
 
A

Alex Dybenko

Hi,
I think crosstab query is a way to go, try to use "jan", "feb" ..etc. and
format your date as Format(DateField,"mm")
you can also make a month number - 1, 2, 3 as "captions" and then cut off
year portion from your date field

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
Top