Search results

I have a text field that looks like 07-08-001 (07 for year, 08 for month, and 001 for record number. How can I automatically increment to the next text/number (eg. 07-08-002) when I bring up a new record? Or is this not possible. I also have to be able to start a new text/number each month...

Here is a problem I am having with a query. I have a table with the following data Fields: "date" "operator" 12/12/2007 American Airlines 01/14/2006 American Airlines / Private 06/30/1956 American Airllines / United Air Lines 01/02/1930 USAir 02/02/2020 United Air Lines 04/04/1940 Northwest...