Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
MT Query create autonumber field
Name: brownpa Date: May 4, 2006 at 08:20:13 Pacific OS: Win XP CPU/Ram: PIIII 3Ghz Product: Dell
Comment:
I am using a Make Table Query. Is there a way to have one of the columns the primary key in the query without going into the table after the MT query has run to create a primary key? If not, is there a way in code that I can make a field the primary key for the new table without having to go into the tables design mode? THank you in advance for your help.
Summary: Access 2000. G'day chaps/chappesses. I'm new to using Access and need a bit of guidance with the following. I have created a table of data which was entered randomly and then sorted alpabetically. W...
Summary: Depends on how your field's are set up. Do you have a field just for the year of donation? If so, just create criteria in your query for that field to =2005. Very simple. Soylent Green is PEOPLE!!!...
Summary: I don't think you can do it all in one field. You might try creating two fields. One a prefix, the other an autonumber. In the prefix you could create a lookup list for the possible types, ad ab ac et...
OE and Messenger
