Append query problems.

M

MrDangerous

I'm trying to use append querys to pull certain bits of info from two
different tables into a third table, but I'm having a problem. One of the
fields is "Invoice Number" an auto-number with a field format of either
/S000000 for sales invoices, and /W000000 for service invoices. That gives
me a 7 character invoice number starting with either S or W that is printed
on a bill. The problem comes in when the query updates the field in the
third table, all I get is the number (both S000003 and W000003 are truncated
to just 3, and so on). How can I get the query to update the field with all
7 characters?
 
L

Luiz Cláudio

In your third table, the Invoice Number must be a text field.

In the append query, you can use an expression like the following:

SalesInvoice: "S" & Fotmat$([Invoice Number], "000000")

The result must be added to your third table's invoice number field.


Luiz Cláudio C. V. Rocha
São Paulo - Brazil
 
M

MrDangerous

Thanks, I'll give it a shot!

Luiz Cláudio said:
In your third table, the Invoice Number must be a text field.

In the append query, you can use an expression like the following:

SalesInvoice: "S" & Fotmat$([Invoice Number], "000000")

The result must be added to your third table's invoice number field.


Luiz Cláudio C. V. Rocha
São Paulo - Brazil


MrDangerous said:
I'm trying to use append querys to pull certain bits of info from two
different tables into a third table, but I'm having a problem. One of the
fields is "Invoice Number" an auto-number with a field format of either
/S000000 for sales invoices, and /W000000 for service invoices. That
gives
me a 7 character invoice number starting with either S or W that is printed
on a bill. The problem comes in when the query updates the field in the
third table, all I get is the number (both S000003 and W000003 are truncated
to just 3, and so on). How can I get the query to update the field with all
7 characters?
Click to expand...
Click to expand...
 
Top