Data Entry

[accessuser1308]

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.

 

[KARL DEWEY]

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.

 

[accessuser1308]

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

 

[accessuser1308]

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