Data Entry

[Guest]

I don't know if this can be done using access, or if I would have to write a
program to do it....

I am trying to make a database to track the work I do. I can process 8
'samples' at a time, which get stored in groups of 96. I would like to make
a form that will allow me to enter my 8 'samples' into a record. Then, when
I reopen the form I would like the 8 'samples' to be blank, but when I enter
new data I would like it to be posted in the next 8 'samples' in the record
(which will track all 96 in the group, such that I will have a report that
will print the group of 96). When the group of 96 is full I would like it to
go to the next record. The work will always be done in groups of 8. Can
this be done with access, or would I need a custom made program?

Thank you for your help.

 

[Joseph Meehan]

I don't know if this can be done using access, or if I would have to
write a program to do it....

I am trying to make a database to track the work I do. I can process
8 'samples' at a time, which get stored in groups of 96. I would
like to make a form that will allow me to enter my 8 'samples' into a
record. Then, when I reopen the form I would like the 8 'samples' to
be blank, but when I enter new data I would like it to be posted in
the next 8 'samples' in the record (which will track all 96 in the
group, such that I will have a report that will print the group of
96). When the group of 96 is full I would like it to go to the next
record. The work will always be done in groups of 8. Can this be
done with access, or would I need a custom made program?

Thank you for your help.

I would suggest that you should go back a couple of steeps. It appears
you database design is flawed and is violating the normalization rules.
"enter my 8 'samples' into a record." Unless those eight samples are
different in some way, like water temperature of a river at 1 foot, 2 foot
.... 8 foot and not just 8 samples then you should should not have eight
fields, but you should have eight records in a related table.

For example.

Table #1
Sample taker: Name
River Sampled: Name
Date Sampled: Date
Sample ID: Number (Unique Number)

Table #2
Sample ID See Table #1
Sample Sub Number: Number(Unique Number)
Sample Value: Value or description

You would have eight records in table #2 for each record in Table #1

Once you date is set up and stored in this format, you will have a more
compact, faster acting and easier to use database.

The above is based on a number of guesses about your data and your
needs. I is possible I just totally misunderstood your question and I could
be totally wrong.

 

[Guest]

Following on what Joseph Meehan wrote your table 2 might look like this --
Table #2
Sample ID See Table #1
Sample Sub Number: Number(Unique Number)
Sample Depth: Value
Sample Temperature: Value
Sample Ph: Value
Sample Solids: Value
Sample Turbidity: Value
Here each single sample will have multiple values.

 

[Guest]

Karl and Joseph,

Thank you for your advice. This worked exactly as I wanted it to, for the
data entry. Now my only question is my report. I have my 8 samples set up
in a row on my report. If I view the report it does exactly as I wish, it
puts my first 8 on a row, then the next 8, and so on. Now, the only thing I
would like to be able to do is have each page of the report only contain 12
rows of data...my storage is 8x12 samples...with the unique name given to the
storage at the top. If I put my storage field in the header it simply puts
the first entry there and lists as many rows of samples as will fit. Again,
I would like to have 12 rows of 8 samples per page of the report, with a
unique name at the top of the page. (The unique name is applied on the
form/table) Is this possible?

Thank you again for your help

 

[Guest]

Please disregard my last post, regarding the report. I figured out how to do
what I wanted. Thank you again for your help.