Recent content by JeremiahClinkerbuilt

Thanks, Like I mentioned, the query runs: (the "*" are necessary for the file import to Xero, all the fields are in the group (or it wouldn't run) - but I hadn't thought about deconstructing the query to find out which part is stopping it working! So thanks for that, I'll give it a try.

Thanks.

Thanks for your replies. I've been mulling it over and going back through my query and code. I don't have any MVF. I tried, and failed. I've removed it now. Could it be lingering? I don't see it anymore. I don;t have any IN clause or the other thing. Below is my query... (I really didn't...

Hi all, I have a query that I can run and show in datasheet view. If I try to export the file to a text file manually (using the ribbon) I get an error: "Too few parameters. Expected 1" (There are no parameters) If I try to export the file to text using VBA (DoCmd.TransferText...