Please Help with Access 97 query IFF statement
Any assistance would be GREATLY appreciated.
In my database I have a select query that is used to input data into a table, "Postage Table".
Once a ticket number is entered I need for the field [Runtime] to check if the ticket number entered was entered previously into the Postage table. If so I need for the runtime field to display that previously entered ticket number's runtime. If the ticket number entered has not been previously entered the user should be allowed to enter the runtime.
I know my IFF statement below is incorrect.
=IFF ([ticket number] = [ticket number] , [runtime] , ())
Thank you for your time.