auto number

[antonov]

hello.
is it possible to get the counter to count up (from 1 to whatever) and
include also the first 3 letters of the current month? (example: 22/sep)

thanks

 

[Steve Schapel]

Antonov,

You would be better to keep the date information in a separate field. I
am not sure what you mean by the "current month", i.e. is it the month
when the record is created or edited, or is it now? Anyway, if you need
the month information with the "counter", this would normally be on a
form or report, and you can concatenate these values in the query that
the form or report is based on.

 

[antonov]

Hello Steve
Current month is the month when the record is created. This also means that
once the number is given it has to remain the same. In excel if I
concatenate the values the date will automatically update itself... but this
is not what I need... say: if I have 25/sep I need to see it this way even
if I open the record in June.

Thanks

 

[Steve Schapel]

Antonov,

I would put a new field in the table, Date/Time data type, let's call it
DateCreated, with its Default Value set to Date()

Then, when you need your data in the required format for your form or
report, something like this...
[YourCounter] & "/" & Format([DateCreated],"mmm")

Would that do the trick?