How can I input the same data many times in a form

[Don Sealer]

I have a database that I need to track certain measurements numerous times
per day. I need to record several aspects like, length, width, thickness,
plus a few other things. I've been recording them in a form and would like
to continue to do it that way. Right now I have one record for each length,
width, and thickness. However the operator is required to check these
things 10 times per day. So each day I have many new records in my form.
This seems to be the wrong way to do it. So I've been looking for another
way. It occurred to me that I could do:
Check# 1 Length Width Thickness
Check# 2 Length Width Thickness
........
Check# 10 Length Width Thickness
With this scenario my table would show Length 1-10, Width 1-10, and
Thickness 1-10. Then I lay it out on my form. It works but it makes for
many many fields.
Is there another way that I could make this happen without creating all
these fields?
Thanks,
Don...........

[Bob Quintal]

"Don Sealer" <vz******@verizon.net> wrote in
news:mLD0f.41$OL5.0@trndny05:

I have a database that I need to track certain measurements
numerous times per day. I need to record several aspects
like, length, width, thickness, plus a few other things. I've
been recording them in a form and would like to continue to do
it that way. Right now I have one record for each length,
width, and thickness. However the operator is required to
check these things 10 times per day. So each day I have many
new records in my form. This seems to be the wrong way to do
it. So I've been looking for another way. It occurred to me
that I could do: Check# 1 Length Width Thickness
Check# 2 Length Width Thickness
.......
Check# 10 Length Width Thickness
With this scenario my table would show Length 1-10, Width
1-10, and Thickness 1-10. Then I lay it out on my form. It
works but it makes for many many fields.
Is there another way that I could make this happen without
creating all these fields?
Thanks,
Don...........

You are already doing it the right way, in that each measurement
has a separate record. Yo talk of having many records in the form.
You should only have one record in the form at a time, that's the
current measurement set your inspector is recording.

If you set things up correctly, the inspector clicks on a menu item
that says "New Measurement" That should open a data entry form
that has the date and time already entered. With a little Visual
Basic programming you can also have it number the Measurement
within the day.

You should have a separate form for doing review of the data, this
can be a continuous list of records.

We have a database for insppection at work, We often add 300
records a week, from the 10 inspectors.

--
Bob Quintal

PA is y I've altered my email address.

[DFS]

Don Sealer wrote:

I have a database that I need to track certain measurements numerous
times per day. I need to record several aspects like, length, width,
thickness, plus a few other things.
Continuing Dr. Kinsey's work?


I've been recording them in a form and would like to continue to do it that way. Right now I have
one record for each length, width, and thickness. However the
operator is required to check these things 10 times per day. So each
day I have many new records in my form. This seems to be the wrong
way to do it. So I've been looking for another way. It occurred to
me that I could do:
Check# 1 Length Width Thickness
Check# 2 Length Width Thickness
.......
Check# 10 Length Width Thickness
With this scenario my table would show Length 1-10, Width 1-10, and
Thickness 1-10. Then I lay it out on my form. It works but it makes
for many many fields.
Is there another way that I could make this happen without creating
all these fields?
Thanks,
Don...........

[Don Sealer]

Thanks for the reply and advice Bob,
I know I'm doing it the right way but I was hoping there would be a way I
could put all 10 checks for the day on one record instead of putting all the
checks for the day into 10 records.
Actually I'm tracking 12 measurements from one machine on average 10 times
per day. I was really hoping not to have 10 separate records but actually
one for the day with all 120 measurements contained in the record.
Can you tell me how many fields Access will allow?
Don...........
"Bob Quintal" <rq******@sympatico.ca> wrote in message
news:Xn**********************@207.35.177.135...

"Don Sealer" <vz******@verizon.net> wrote in
news:mLD0f.41$OL5.0@trndny05:

I have a database that I need to track certain measurements
numerous times per day. I need to record several aspects
like, length, width, thickness, plus a few other things. I've
been recording them in a form and would like to continue to do
it that way. Right now I have one record for each length,
width, and thickness. However the operator is required to
check these things 10 times per day. So each day I have many
new records in my form. This seems to be the wrong way to do
it. So I've been looking for another way. It occurred to me
that I could do: Check# 1 Length Width Thickness
Check# 2 Length Width Thickness
.......
Check# 10 Length Width Thickness
With this scenario my table would show Length 1-10, Width
1-10, and Thickness 1-10. Then I lay it out on my form. It
works but it makes for many many fields.
Is there another way that I could make this happen without
creating all these fields?
Thanks,
Don...........

You are already doing it the right way, in that each measurement
has a separate record. Yo talk of having many records in the form.
You should only have one record in the form at a time, that's the
current measurement set your inspector is recording.

If you set things up correctly, the inspector clicks on a menu item
that says "New Measurement" That should open a data entry form
that has the date and time already entered. With a little Visual
Basic programming you can also have it number the Measurement
within the day.

You should have a separate form for doing review of the data, this
can be a continuous list of records.

We have a database for insppection at work, We often add 300
records a week, from the 10 inspectors.

--
Bob Quintal

PA is y I've altered my email address.

[Dean]

I don't think I would put all 120 measurements in one records.

You might put a date field in and then on your form create a pull down
that allows the user to filter records to one day at a time.

[rquintal]

Access will allow 255 fields per record. However, storing 120 different
measurements in a single row will make statistics a nightmare. Even
storing the 12 in one row is a terrible idea, in the long term.

Why are you concerned about the number of records? If it's a user
interface issue, we can try to suggest ways to help, but we'll need to
know what the real problem is.

Access has very powerful tools for summarizing data, if you lear to use
them correctly, you can really harness the information your
measurements contains.

Q