creating autofill fields

[ChristieB]

So I need to create an automatically generated record in a table when the
previous fields time goes into the next day. For example. If a employee
input his time as 9Pm-2am on 1/1/08, I need to automatically generate a
record that has the time from 00-2am with the next days date:1/2/08 I also
have to cap each days time at 12 midnight. I am not sure where to start with
this entire sequence, can someone give me some guidance? Thanks. Christie

 

[Jeff Boyce]

You've described "what", but not "why".

You've described "how", but not explained what having this kind of data will
allow you to do.

It all starts with the data ... so if you'll describe a bit more
specifically what your data structure is, the folks who frequent this
newsgroup may be able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[ChristieB]

We need an autogenerated record so that we don't have to go into the tables
and generate it when a person works beyond midnight, them entering their
time, it will update automatically. Having this data will help us keep
seperate each days time records. It will help when generating payrolls and
calculating hours worked. Thanks for your help.

 

[Jeff Boyce]

Christie

If I have a table that stores StartDateTime and EndDateTime information, I
can use queries and reports to derive "per day" totals. It may be that
you'd need to generate separate records for each day if you were using some
tool other than a relational database like Access, but it isn't necessary
(and it IS undesireable) to treat Access like a spreadsheet...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP