Is it possible to enter multiple data to one field per record?

Is it possible to define a field that can accept multiple data for one
record? I am building a maintenance database and to add multiple dates to
one field for one product would save a great deal of time with the data entry
process. The example is the product requires maintenance every Wednesday
morning. Instead of filling out a new record 52 times for the year. Is it
possible to add 52 different dates for the one record / product???

Thanks

It would be better to create a process that handles reoccurring events.
Create a dialog box that the user enters the start date, the day(s) of the
week the event is to occur on, and the number of occurrences (or occurrence
end date).

Entering more data into a field, like you have described, will be a
nightmare to, not only maintain, but to report on for queries and reports.

HTH


--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com


"Matt" wrote in message
...
Is it possible to define a field that can accept multiple data for one
record? I am building a maintenance database and to add multiple dates to
one field for one product would save a great deal of time with the data
entry
process. The example is the product requires maintenance every Wednesday
morning. Instead of filling out a new record 52 times for the year. Is
it
possible to add 52 different dates for the one record / product???

Thanks

That is what I was afraid of. My talents in the db world is pretty basic.
However...can you recommend a good site that might discuss the solution you
provided???

Thanks again for the assistance.

"RobFMS" wrote:

It would be better to create a process that handles reoccurring events.
Create a dialog box that the user enters the start date, the day(s) of the
week the event is to occur on, and the number of occurrences (or occurrence
end date).

Entering more data into a field, like you have described, will be a
nightmare to, not only maintain, but to report on for queries and reports.

HTH


--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com


"Matt" wrote in message
...
Is it possible to define a field that can accept multiple data for one
record? I am building a maintenance database and to add multiple dates to
one field for one product would save a great deal of time with the data
entry
process. The example is the product requires maintenance every Wednesday
morning. Instead of filling out a new record 52 times for the year. Is
it
possible to add 52 different dates for the one record / product???

Thanks

I don't know of any sites off the top of my head. Look via google for
keyword "RecordSet".
Find examples that will show you how to create and destroy recordsets. With
the recordsets, how to update and append data.

HTH


--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com


"Matt" wrote in message
...
That is what I was afraid of. My talents in the db world is pretty basic.
However...can you recommend a good site that might discuss the solution
you
provided???

Thanks again for the assistance.

"RobFMS" wrote:

It would be better to create a process that handles reoccurring events.
Create a dialog box that the user enters the start date, the day(s) of
the
week the event is to occur on, and the number of occurrences (or
occurrence
end date).

Entering more data into a field, like you have described, will be a
nightmare to, not only maintain, but to report on for queries and
reports.

HTH


--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com


"Matt" wrote in message
...
Is it possible to define a field that can accept multiple data for one
record? I am building a maintenance database and to add multiple dates
to
one field for one product would save a great deal of time with the data
entry
process. The example is the product requires maintenance every
Wednesday
morning. Instead of filling out a new record 52 times for the year.
Is
it
possible to add 52 different dates for the one record / product???

Thanks

You might want to take a look at the Recurring sample database at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. This
solution speeds up the entry of multiple records based on a variety of date
intervals.
--
Duane Hookom
MS Access MVP

"Matt" wrote in message
...
Is it possible to define a field that can accept multiple data for one
record? I am building a maintenance database and to add multiple dates to
one field for one product would save a great deal of time with the data
entry
process. The example is the product requires maintenance every Wednesday
morning. Instead of filling out a new record 52 times for the year. Is
it
possible to add 52 different dates for the one record / product???

Thanks