Table Entries

[melb]

Is there a quicker way to enter in say 5 entries into a table where they only have one variable differing. There are at least 10 variables that stay the same for each entry with only one changing over the entries. What would be the best way to do this?



I've tried creating a form that will serve the same purpose but it's a bit beyond the scope of my epertise now.

[JoeM]

I would question the design of your database, it may not be normalized.
Typically, if you have a lot of repeating data in a table, you may have an instance in which the table should really be split into multiple tables.

See here for information on normalization: https://support.microsoft.com/en-us/kb/209534
There is a lot more information that can be found on that concept too, with a Google search.