Access 2000 and VB: What is the command to insert data in a field?

[iamwiz82]

Here's the situation. I need to sort data using the following format: mm/yy(ie: 02/02). Access cannot do this, instead, it created 02/01/02. So, it was decided in OT that i would use 02/02 as a text box on input, and then create a hidden field that would take the month and the year off the string, create a date in the form of 02/01/02 and then sort by that.

This is an excellent idea, and i know how to remove the month and year, using Left and Right, but how would i put the new string into the hidden field for each record??

 

[iamwiz82]

bump