Line Spaces In Query?

[DeanRowe]

Hi,

Does anyone know if its possible to have a page break/line space in a query's results?

For example, a query returns 5000 results, and after every 45 there is a space of 2 or 3 spaces. When I say "space" it could be a couple of empty records or rows.

The reason I ask is because I use a query to filter the records I want from my table. I then use a make table query to make a new table with these records, then I use a macro to export the table into a .txt file.

This text file is then used as a product feed, except the web application I use to import the data can only take a maximum of 50 records - so it'd be nice to already have a space so when I cut and paste the records into the web application I don't accidently try to import 51 records and mess everything up.

I know it's a strange one, but if theres anyway of setting the format of the .txt file to contain spaces would save a lot of time.

Any ideas would be welcomed, thanks for your time.

Dean

 

[KeithG]

Check out the attached example. When you run the function in module it will create a text file from tblName and after every 50 record it will write two blanklines to the file. You may need to change the location that the file is saved to. Let me know if this works for you.

 

[DeanRowe]

Hi KeithG,

Thank you for replying, I've never touched modules with my experience to date, I might be having a dumb moment but I can't seem to "run" the module, when I double click on it, it only brings up the code.

I'm using Access 2000 btw.

Thanks again KeithG

 

[DeanRowe]

Hi Keith,

I changed the file name from H: drive to C: drive and it works perfectly, thank you for your help.

Dean