adding "one" to a text field (number)

[Scuda]

Hi all,

I am creating a work schedule in access and after looking at some of the
other great examples I figured I would mess around with making my own.

it is going to be a monthly work schedule for 4 different groups of people,
2 people per day (12 hour shifts).

So, in my table I made Day1, and what I would like is to have Day2, Day3,
etc. Automatically be populated with the next number. ie: Day 2 be plus 2,
Day 3 be plus 3, etc. So when I first go to the form, I pick the date on say
a Wed (first day of that month) and have the remaining days filled in.

Can I do that?

Thanks!
Steph
Thanks!

 

[Jeff Boyce]

Are you saying you are trying to name fields "Day1", "Day2", "Day3", ...
"Day-n"?

If so, this is a very spreadsheetly way of handling this ... and will cause
you and Access no end of headaches down the road.

Or have I mis-read between the lines?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Scuda]

No, you are right lol - and I know it is a spreadsheat-ian way of doing it!

So what is the BEST way to do it and I will approach it from that angle.

Thanks!

 

[Jeff Boyce]

"Best" is such a subjective term...<g>

When I approach a new database, I first shut off the computer and pick up
pencil and paper. To get the best out of Access, it's worth the time it
takes to normalize the data. Check at Jeff C's site for extensive
references:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101

Pencil and paper, because drawing out the "entities" and "relationships" is
a good starting point for the tables (and relationships).

For example, if you have multiple "days" you want to track, consider
including a field in a table that holds "YourTrackingDate". You can always
calculate what the date would be 23 days after "YourTrackingDate" by using a
query and, say, the DateAdd() function.

If you provide a bit more information about the domain (what subject area
are we working in?), the newsgroup readers will probably be able to offer
more specific suggestions for data structure...

Regards

Jeff Boyce
Microsoft Office/Access MVP