Let me start by saying I am new to access reports and sql so here is what I have done so far:
I have a 4 column report that pulls data for 3 of the columns from a sql database. When you run the report it prompts for the start and end dates. There are 4 columns (License #, Name - which is made up of 4 sql fields (First, Middle, Last, suffix), Date and Document #).
Here is my problem the Document # is not stored in a table and I don't need to store the information in a table but I need it to prompt the user for the information for each record and record it record and display it on the report. I would like to have a prompt like "Please enter document # for license # (Display current record License #):"
Is this possible to do from a form?
I have a 4 column report that pulls data for 3 of the columns from a sql database. When you run the report it prompts for the start and end dates. There are 4 columns (License #, Name - which is made up of 4 sql fields (First, Middle, Last, suffix), Date and Document #).
Here is my problem the Document # is not stored in a table and I don't need to store the information in a table but I need it to prompt the user for the information for each record and record it record and display it on the report. I would like to have a prompt like "Please enter document # for license # (Display current record License #):"
Is this possible to do from a form?