Recent content by kebab

Thanks for the quick reply. I am sort of new at this. My database is "plans.mdb" My only table is "plans" My only form is "plans" The field in question is "plan check #" As I understand it: I add a date field called, let's say, "Current Date" with a default value of Now() I add a number...

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...

Thank you. That did the trick.

I'm so sorry to bother you again. As I wrote above, following your instructions, the query worked perfectly in test.mdb. However, when I applied it to may real database aviation.mdb (changing the table names accordingly) it would not work. I must have worked on it for five hours trying to see...

Wow! Worked like a charm. Thank you for all your time and expertise.

OK. I have attached the zip file test.zip which contains test.mdb. All I want to do is develop a query that will take "Original" table and make a new table that will be called and look like "Modified" table. Thanks.

Would it be possible for me to send you the test Access file I am working on?

I ran the query and received a compile error. "compile error, in query expression InStr(1, T1.Operator, '/') = 0" My starting table is called Original My ending table is called Modified The two Fields are "Operator" and "Date" Here is the whole text I copied into the SQL SELECT T1.* INTO...

Unfortunately, I am somewhat new to Access. Can you direct me step by step where to put the code. Thanks.

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...