Display specific field from previous record

[spudracer]

I have been working on a database, for some time now. One of the issues I have, is that for every new record, the next number in the series needs to be used.

Now, I have records I create, and records that come into me that I track, as well.

Here are the two fields I am concerned with.

Originator Number [ON] (Can be either mine or from another office)
Inventory Number [IN] (Only I assign)

So, what I want to be able to do (if it's possible), is have a box that shows the last number, for both Originator and Inventory if it meets specific criteria.

I would want these fields to display the numbers from the last record that had my office's code in the field. Is this something that is possible?

 

[jzwp22]

Based on what you have posted, it sounds like the DMax() function may work. The domain aggregate functions (DMax(), DLookup(), DMin(), DCount()) etc. can be a little difficult to work with at first because of the syntax of the function, so you will want to check the help section.

 

[spudracer]

Great! Thanks for your help!

 

[jzwp22]

You're welcome.