Count Record

[JakeL]

Hi, I am pretty new to Access, seeking some help from Pros here ~



How do I show the number of drivers that I had added for a particular vehicle no. in a form when I select the vehicle no. (Eg, EX123X) and could be auto update as and when I add a new driver in.

[June7]

Is form in Single or Continuous view? Is the form filtered to that vehicle number? Have a textbox in form header or footer section with calculation: = Count(*)

The calculation will update when new record is committed to table.

If you want to provide db for analysis, follow instructions at bottom of my post.

[JakeL]

Hi June7,

The Additional Driver Section is a Subform of Motor Insurance. I would like to know how many additional driver have I include for a particular vehicle no.

[June7]

So what is the expression in that textbox with the error?

Did you attempt what I suggested?

[orange]

It seems you would/could have these base tables:

TableVehicles --where each vehicle i uniquely identified and gas info about a specific vehicle
TableDrivers ---where each driver i uniquely identified and has info about a specific driver

then a junction table, such as

tblVehicleHasDrivers -- where each record uniquely identifies the Vehicle and driver combination (compound PK)

Consider, vehicles veh1, veh2, veh3 and drivers DrvA, DrvB.... where DrvA can drive Veh1 or Veh3 and DrvB is limited to Veh2.

tblVehicleHasDrivers would have records (and other relevant data based on your requirements)

vehicleID Driver ID
veh1 DrvA
veh3 DrvA
veh2 DrvB
......

Good luck with your project.