Emmanuel
Master Tech
- Local time
- Today, 09:37
- Joined
- Sep 4, 2002
- Messages
- 88
Hi people,
I am creating a query which is going to append some invoices to a table. This table has some fixed length for example the invoice number field has 12 spaces and some invoices are 7 or 8 characters. How can I create a query that will append the values to this with its format regardless of the invoice number?
Regards,
Emmanuel
I am creating a query which is going to append some invoices to a table. This table has some fixed length for example the invoice number field has 12 spaces and some invoices are 7 or 8 characters. How can I create a query that will append the values to this with its format regardless of the invoice number?
Regards,
Emmanuel
