Export Text: too few parameter, expected 2.

D

David

and then it stops. The SQL is posted. When the query results display, I
want to Export them to a .txt file. I select File Export and give it a
filename and location. Then I get the error. It worked fine for a few
months and then just stopped yesterday... after some issues with 'hidden'
files. Can anyone help? Thanks

SELECT "CID" & "-" & [tblbriefs].[id] & "-" & Right([tblbriefs].[orderno],6)
AS CID, tblBriefs.OrderNo, tblBriefs.[Business Name], tblBriefs.ShipToFName,
tblBriefs.ShipToLName, tblBriefs.ShipToPrefix, tblBriefs.ShipToStr1,
tblBriefs.ShipToStr2, tblBriefs.ShipToCty, tblBriefs.ShipToSt,
tblBriefs.ShipToZip, Left([shiptozip],5) AS zipfive, tblBriefs.email,
tblBriefs.ShipToCntry, tblBriefs.StampDate, tblBriefs.Phone
FROM tblBriefs
WHERE (((tblBriefs.ShipToStr1) Is Not Null) AND ((tblBriefs.StampDate)
Between [Enter Start Date (mm/dd/yy)] And [Enter End Date(mm/dd/yy)]));

PS, the two data-entry parameters are date and I enter 07/20/09 and 08/03/09
and the query displays but that's as far as it will go.....
 
D

David

Adding to this post: when I choose File Export and select datatype of Excel
(xls), it works fine.. it's just when datatype is .txt that it stops.
 

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

Top