default value based on criteria

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

Guest

I need a little help creating a particular default value if this is possible

Lets say I have several vehicles with different numbers attached to them,
23, 43, 504, etc.

43 already has 3 entries along with the other vehicles (each on a separate
record).
In these entries there is a field for the "Last" kilometres readout, and a
field for present kilometres.

Assume I'm making another entry for 43 for the following scenario. Is it
possible for me to create the default value for "Last" kilometres based on
the Present kilometres from the last entry for 43 regardless of its position
in the recordset?
Ideally, it would be nice to be able to do this for all entries.
 
I feel like an idiot, I figured it out just after I posted this.
Dmax worked considering it was kilometres I was going by. Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add multiple values on table based on listbox 0
Getting "default" value from table 3
User Sets Control Default Value 1
Filter a second form based on primary form 3
Defaulting fields 1
Populate Field Based on Value of Previous Record 15
Default date does not save to the record 1
Update field based on criteria from another record (row) 3

Back
Top