Keep in mind I am new to Access.
I have created a report showing my ticket.
I want to put the same number on each side of the ticket.
I need tickets 0001 to 0200
Do I create an update or apend query. How do I do it?
Keep in mind I am new to Access.
I have created a report showing my ticket.
I want to put the same number on each side of the ticket.
I need tickets 0001 to 0200
Do I create an update or apend query. How do I do it?
You don't need a query. This can all be done on a report with visible and invisible controls and using the Sum feature of the control.
You better point me in the write direction?
Do you have these ticket numbers stored in a Table?
If so just use the same field as the Control Source for two different text boxes.
If you don't have these numbers stored then we need to try something else.
Let me know what you want to do.
Yes they are in a table.
I was able to create fields the would link to the table and show the ticket numbers.
Thanks
That works