Serializing records -record count!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I have an HR database that contains multiple tables with various unique
records, all linked to an employee record. For example, "personal
information" linked to "disicplinary actions" or "first aid records".

Currently, when I access a First aid record, a query is run that limits the
records to the individual, and this works just fine. Out of 500 or so
records, up comes the 4 for "joe smoe".
The problem I have is that I want a record count to be automatically
ammended in the table each time my macro creates a new first aid record for
"joe". While the new record displays the employee's name, and any other data,
it will not add a new value to the "record number" field. Currently , i
manually type in the number that is displayed below in the record display
(I'm not sure what that is called, sorry!)
I tried running a count query, and then adding that returned value + 1,
however, access would not let me use that number to add data to my form, and
thus the table!

This seems like a fairly common question about access: How does one get a
record count number added to a form? (Bearing in mind that this set of
records are already parred down by a query...)

I hope I have explained this adequately... I 'm not very adept at access, so
any help would be appreciated!
 
T. Skillman said:
Hi. I have an HR database that contains multiple tables with various unique
records, all linked to an employee record. For example, "personal
information" linked to "disicplinary actions" or "first aid records".

Currently, when I access a First aid record, a query is run that limits the
records to the individual, and this works just fine. Out of 500 or so
records, up comes the 4 for "joe smoe".
The problem I have is that I want a record count to be automatically
ammended in the table each time my macro creates a new first aid record for
"joe". While the new record displays the employee's name, and any other data,
it will not add a new value to the "record number" field. Currently , i
manually type in the number that is displayed below in the record display
(I'm not sure what that is called, sorry!)
I tried running a count query, and then adding that returned value + 1,
however, access would not let me use that number to add data to my form, and
thus the table!

This seems like a fairly common question about access: How does one get a
record count number added to a form? (Bearing in mind that this set of
records are already parred down by a query...)

I hope I have explained this adequately... I 'm not very adept at access, so
any help would be appreciated!
Click to expand...

It isn't a common question, because it is poor data design. A count of
related records in another table is derived data, and it is bad practice to
store derived data. Just calculate it with a query whenever you need to
display or report it.
 
Back
Top