Hi
I was after some help from an utter Access beginner.
I have a large table of data in Access, it is GPS data for a fleet of vehicles, called "Vehicle_GPS". I would like to split this large table into several smaller tables, one for each vehicle. Each vehicle is identified by its registration, in a field called "Reg".
There are a lot of vehicles so it would be good to automate the process rather than manually selecting and copying into new tables.
I want to split the large table into smaller tables so each of the smaller tables contains the data only for one vehicle (Reg). So if there are 40 vehicles, I would like to create 40 separate tables each containing the data for that specific vehicle, possible naming the table by the registration as well if possible.
Any help would be gratefully received!
Thanks