Syntax Help Please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I pull this up in excel it shows the primary fax number in the first
column but it appears it concantantes the ContactName and AccountName the
second column.

I am trying to get this to write 3 seperate columns.

a.writeLine rs("PrimaryFaxNumber") & ",""" & rs("ContactName") & ",""" &
rs("AccountName") & """"

Any help would be appreciated
 
You may be missing the closing quotes between ContactName nad AccountName:

a.writeLine rs("PrimaryFaxNumber") & ",""" & _
rs("ContactName") & """,""" & rs("AccountName") & """"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help!Error 3265, loading fr cbo box to combo box and then to txt b 1
Import File Information 0
Send Object Help 2
ALTER TABLE syntax error 4
Help with code 5
Showing global variable in a report?? 1
syntax - how many fields a table has 3
Smoothed Average runs slow 1

Back
Top