View Full Version : putting created autonumbers into numerical fields in a query


aussieolie
04-05-2002, 09:02 AM
How do I put multiple autonumbers (with a query) into a numerical field?

Thanks

Pat Hartman
04-05-2002, 09:10 AM
For one thing, you can't put multiple numeric values into a numeric field unless you are summing them and storing the total. Technically you could concatenate them in a text field, however, it is NEVER correct to store multiple values in a single field. Do a little reading on database normalization. There are excellent articles in the Microsoft knowledge base and by using the search feature on this forum you should be able to find links to them.