VBa To Find Smallest Id Value

[CharlesWhiteman]

My Db takes enquiries and on my enquiry form there is a text box to write some notes about the enquiry. The note is then entered into TblHistory where additional history notes can then be added.

So in TblHistory there are many notes about enquiries. Each note in TblHistory also has a field to denote its relationship to TblEnquiries. So in TblHistory there is a field TblEnquiryID

Is there any way (like the opposite of DMax) to look at the TblHistoryID's for that enquiry and identify the first note?

Thanks

 

[pbaldy]

Like DMin?

 

[CharlesWhiteman]

Yes, but I didnt htink there was a Dmin?

 

[pbaldy]

There is.

DAvg
DFirst
DLast
DMin
DMax
DCount
DSum
DLookup

 

[CharlesWhiteman]

Thanks muchly P! So there is a DMin!! doh!

 

[pbaldy]

No problemo!