Append query problems.

[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?

 

[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

 

[MrDangerous]

Thanks, I'll give it a shot!

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

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?

 

[Luiz Cláudio]

Typo:

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

 

[MrDangerous]

I caught the typo, and it worked like a charm. Thanks a bunch.

 

[Guest]

MrDangerous escribió:

I caught the typo, and it worked like a charm. Thanks a bunch.

Typo:

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

quiero recibir spam y no me importa de donde