470,849 Members | 1,233 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,849 developers. It's quick & easy.

numbering (like autonumber) records in a table

I have a MakeTable query whose resulting table i'm using in a crosstab query. The fields in the crosstab are constantly changing (weekly), so my ultimate goal has been to somehow create a dynamic report that takes into consideration the ever changing fields. that's been VERY tricky.

I've managed to get the MakeTable query to only display my 'top 10' fields and i've created a 'static' report that references a calculated field (Number) in that table. In effect, if i can automate the creation of an autonumber field within this 'made' table and call that field 'Number' (where the values would be 1 to 10), then my report will always look to that field for the report.

where i'm stuck is in automatically (either by macro, procedure or funtion) creating that Number field. I found this fellow's function (http://www.lebans.com/rownumber.htm), but have not been able to figure out how to apply it properly.

seems it would be MOST nice if i could create an OpenTable macro that simply added an autonumber field called Number... but that may just be impossible.

any help is greatly appreciated... i'm running XP and Access 2003 (SP 3)

Aug 28 '08 #1
1 1340
32,311 Expert Mod 16PB

I think it may be possible to add the field you require.

Check through How to ADD a column at FIRST in a table for a discussion on adding fields and moving their positions in the table.

If this seems to be what you want let us know and we can help find a solution I expect.
Aug 29 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Grim Reaper | last post: by
5 posts views Thread by Charles McCaffery | last post: by
1 post views Thread by Wayne Aprato | last post: by
5 posts views Thread by Lee-Anne Waters via AccessMonster.com | last post: by
9 posts views Thread by Gogo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.