I have this program that adds information to a ms database file in a very odd manner.i cant change the way the information comes in but is there a way to move it into the correct location in a new table. information is put in as a group of 19 records.

whats happening is this:
these are the colums
primary key,group id,info,info,info,group order,info,info,info

i need to information from 4 of the colums into a new table so i have 19 colums and 1 record.

is this even possible.

Frustrated net admin

Use an maketable query to concantenate the 4 fields into the 19th.

The of course violates normalization rules. Never store data that can be calculate.

Sometimes, I think, that it's more practical to use/make non-normalized tables. But there's always a price down the road.