G
Guest
I have a table and form where there is a field named Supplier Source Code
where users enter the next available letter or double letters (A through GG
currently) and date that a supplier is approved. I need a button in the form
that will show the last letter used which probably should be based on the
latest date. I've made a query using the Source Code field and the date
issued field. Do I use one field in the query and use one expression or two
fields and two expressions? What is the expression I should use?
where users enter the next available letter or double letters (A through GG
currently) and date that a supplier is approved. I need a button in the form
that will show the last letter used which probably should be based on the
latest date. I've made a query using the Source Code field and the date
issued field. Do I use one field in the query and use one expression or two
fields and two expressions? What is the expression I should use?