Search results

I have attached by table and form. I need to have an autonumber for receipt when the entry is an income and similary an autonumber for the voucher when the entry is an expense.

Dear Friends, I am having a table for invoicing and vouchers, and I need to have two fields that will have auto incremental numbers. Can you please help me understand how I can have two fields in the same table with autonumbers and how can I get one of them to start from a different value. Eg...

Dear Friends, I am trying to create a table for income and expense [catergory] and would like the amount being entered into the [amount] field to have a negative or positive value on entering based on the category chosen. so in my table I have [catergory] which is chosen from a look up...