Search results

Hi, Is there a way to search data using a calculated data field. On 'EntryForm', name, address, contact, date(Dt) and serial number(Sr) are entered which are combined to produce a calculated result using formula - Year[Dt] *10000000+Month[Dt]*100000+Day[Dt]*1000+[Sr] There is a separate...

Hi, I am making a database to manage my banking transactions, similar to ledger. The table table would contain 6 fields. Serial no, date, detail, deposit, withdrawal and balance. I have made a form to enter serial number, date, detail, deposit and withdrawal. The report is generated to show...

Hi I solved the problem by using year, month and day function and adding it to serial no. Thanks for all your helpful suggestions.

I haven't made database yet. Just begun and struggling with registration of customer part.

Till now, I used manual register to enter customers details such as date of transaction, serial number and order details. I wanted to shift to computers for recording of transactions. I wanted a column containing a unique registration number for every customer so that it can be used in future...

Your suggestion to use yyyymmdd format was very helpful. Thank you sir.

I tried using update query but have to close the form after data entry and reopen the form, run the update query, close the form again, open the table to reflect the changes in tables.

Hi, I want to create a database where i can enter date, and serial number for customers. I want a third field which uses entered date as ddmmyyyy and joins it with serial number making it into a unique registration number. Example - Date of entry - 1/30/2019 . Serial number...

Hi all.. Nice to be here