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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Back
Top