use the above function and just change the > to < like this... vb Code: If CSng(strTemp) < sngNum Then this should help you....
If CSng(strTemp) < sngNum Then
If an answer to your question has been helpful, then please, Rate it! Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes. Useful Codes Capture Special Keys' Status - Create DSN thru VBCode - Add Serial Number / Row Number to SQL Queries
Forum Rules
Reply With Quote