Recent content by jmlbones

Thanks all...I will give these a go.

I have phone numbers in a table as "(123) 456-7890" and I need to convert them to "123/456-7890" within a query. Can anyone help?

I have a table with phone numbers represented as "(123) 456-7890". I need to convert these phone numbers in a query to appear as "123/456-7890". Can anyone help me?

I have a worksheet that has the print area and layout that appear to be correct in the print preview (landscape). However, when I go to print, it prints in portrait. The print settings are set to print the print area by 1 page wide and in landscape mode. When it prints it is in portrait and...

I have a table that stores phone numbers and zip codes as text format. A phone number looks like this 1112223333 and a zip looks like this 111112222. I am trying to export to a fixed length text file that requires phone numbers like this 111/222-3333 and zips like this 11111-2222. Is there an...

I have a table that stores phone numbers and zip codes as text format. A phone number looks like this 1112223333 and a zip looks like this 111112222. I am trying to export to a fixed length text file that requires phone numbers like this 111/222-3333 and zips like this 11111-2222. Is there an...

Thanks. Got it to work.

I will give it a try. Thank you.

How can I combine data that is in two fields into one? I have to create one Name field from the First Name field and the Last Name field. Thanks.

I have a Contacts table that has a First Name field and a Last Name field. I eventually want to export data into an Excel spreadsheet in a single name field. Is there a way I can do this by either adding a field to the existing table, creating a new table, or just combining them when I send...

That was it. The format for the field within the specification was not set to text. Thanks again.

Thanks for the info. I was able to use your suggestion to get the query to display the date in the format that I needed. However, now when I run the export from the query to the text file I receive an error stating that data was lost. I updated my import/export specification to reflect the...

I have table that needs to be exported to a text file. This table contains a few fields that contain date fields. For example, on record as a value of 01/02/00. I need to export this table to a text file where this value should be 20000102. Is there something I can do within the format of...