Multiple values in one field

Kclynn

Board Regular
Joined
Jan 23, 2020
Messages
66
Office Version
  1. 365
Platform
  1. Windows
I am very new to using access for creating a db. Can a field hold multiple selections? i.e. If we sell different types of equipment and I want to select all the different pieces of equipment they purchase for there project can a field be formatted as an array to hold several sel
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
You should research Normalization to understand database design principles.
And this is a key point in Codd's rules on relational database.

Data should be "atomic". That means that data should be stored in its most basic, indivisible
form; for example, avoid storing an address as a single data element, with street number,
street name, apartment number, city, state and zip code. Each of these are separate pieces of

data and should be stored in separately.
 
Upvote 0
I am very new to using access for creating a db. Can a field hold multiple selections?
jackd is absolutely right that this is not good design but in Access it is possible to do. If you are just throwing together a database for yourself for some quick analysis or logging, you can possibly get by using a multivalue field (I have). If you are creating a database app that will be used by other people, you should not use this approach and instead normalize the data as jackd suggests.

Here's MS's article on using multivalue fields in Access:

 
Upvote 0

Forum statistics

Threads
1,213,563
Messages
6,114,332
Members
448,566
Latest member
Nickdozaj

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top