Data Type Error?

[mikesal57]

Hi All...



I have this field called tPGM (Program Number)

It can range from 1-20 but sometimes it can be ...1A or 2B or 3C , etc etc

I need to export this in Excel but it leaves the fields blank if it has the letter in it..

.

Can this be fixed ?

Thxs

[Welshgasman]

Try prefixing the field with a single quote in a query. Export that.

[mikesal57]

Try prefixing the field with a single quote in a query. Export that.

Thx but I'm lost on that....can you expand please...

[Welshgasman]

Something along the lines of

SELECT tblSubmitterInvoice.SubmitterClientID, tblSubmitterInvoice.TransferFeeID, tblSubmitterInvoice.InvoiceRate, "'" & CStr([nvoiceAmount]) AS AmountText, tblSubmitterInvoice.DateInvoiced
FROM tblSubmitterInvoice;

I am using my fields here. You could try with and without the Cstr()

Just create the query in the query designer.