New to expressions* Need EntryNumber to add 1 when EntryTitle matc

S

SCrowley

I've looked around the discussion group; however, not sure if I'm asking the
right question.

I have db with identifiers: Entry Title and Entry Number. I would like for
the entry number to automatically add 1 to the last entry number that matches
the entry title. For example:

Existing: Xerox Services, LLC (entry title)
1 (entry number)

New Entry: Xerox Services, LLC (expression looks at last entry number for
Xerox Services, LLC and adds 1) Result 2 (entry number)
 
F

Fred

I noticed that nobody answered.

If you will excuse my directness which is an attempt to be helpful........
To have a question be clearly understandable, may I suggest that when you use
terms in places essential to defining the question that you use Access terms
rather than terms which you made up ("Identifiers" "Entry Number", "Entry
Title".....I'm guessing the the latter two are field names? ) where people
can only guess what they are and what them mean.

Taking my best guess at you question, a simple way to 99% do what you want
would be to turn the "EntryNumber" field into an Autonumber field. To go
further to cover that last 1% would be much more complex.

Sincerely,

Fred
 
S

Sandy Crowley

Thank you, Fred, for taking pity on me and answering my question.

I like 'direct' answers.

My lack of syntax knowledge led me to asking a question speaking the wrong
language. FYI when I used the help feature for expression builders it says
"Identifiers — the names of table fields or controls on forms or reports, or
the properties of those fields or controls." and I thought I was using the
proper venacular. As far as the Field Names I will be more specific.

Yes, I want an autonumber, however, I want the autonumber to be related to
the Field Name "Vendor Name".

For every Xerox (Field Name VENDOR) I need the (Field Name Entry Number),
which records the next entry number, to incrementally increase by 1. If I
have 5 Xerox entries the first entry will be 1, next 2, next 3, etc.

For every TWC Business Class (Field Name VENDOR) the first entry (Field Name
Entry Number) is 1, next 2, next 3, etc. Without me having to look at the
previous entries and manually incrementing and entering therefore eliminating
operator error.

I hope this clarifies what it is I'm trying to do.
 
C

Clif McIrvin

Sandy Crowley said:
Thank you, Fred, for taking pity on me and answering my question.

I like 'direct' answers.

My lack of syntax knowledge led me to asking a question speaking the
wrong
language. FYI when I used the help feature for expression builders it
says
"Identifiers - the names of table fields or controls on forms or
reports, or
the properties of those fields or controls." and I thought I was using
the
proper venacular. As far as the Field Names I will be more specific.

Yes, I want an autonumber, however, I want the autonumber to be
related to
the Field Name "Vendor Name".

For every Xerox (Field Name VENDOR) I need the (Field Name Entry
Number),
which records the next entry number, to incrementally increase by 1.
If I
have 5 Xerox entries the first entry will be 1, next 2, next 3, etc.

For every TWC Business Class (Field Name VENDOR) the first entry
(Field Name
Entry Number) is 1, next 2, next 3, etc. Without me having to look at
the
previous entries and manually incrementing and entering therefore
eliminating
operator error.

I hope this clarifies what it is I'm trying to do.
Click to expand...


Sandy, the learning curve can be daunting -- figure in terms of months,
not weeks.

I've seen a general concept for what you want in these discussions,
though I've not used it myself; and I don't have a reference to a
specific thread to share with you.

The concept I'm thinking of will use the DMax domain aggregate function
to return the highest used entry number associated with a specific
vendor. Search the discussion archives for keyword DMax.
 
S

Sandy Crowley

Clif,

Thank you very much. I see snippets of what I want to do in the DMax threads.

You and Frank have been very helpful!
 
C

Clif McIrvin

Sandy Crowley said:
Clif,

Thank you very much. I see snippets of what I want to do in the DMax
threads.

You and Frank have been very helpful!
Click to expand...

You're welcome!

Come back with more questions if it doesn't come together for you. the
help in this forum is incredible!
 
Top