Hello,
Brand new Access user here , having first looked at the program a week ago. I've stumbled through my first database and have something that seems to work well enough for my purposes but would probably make more experienced users cringe.
I'm working on a report to generate a text file that will be fed as input into a different computer program, so the file needs to be in a specific format. The report I've generated is pretty much what I need, but I'm still figuring out the formatting process and if anyone can help I'd appreciate it.
The report I have has just two fields, a room and a list of equipment in that location, the current output looks something like this:
Room A
Equipment 1
Equipment 2
Room B
Equipment 1
Equipment 2
Room C
Equipment 1
Equipment 2
The only thing I need to do is get rid of the blank lines between all the entries associated with each room, like this:
Room A
Equipment 1
Equipment 2
Room B
Equipment 1
Equipment 2
Room C
Equipment 1
Equipment 2
Any suggestions for getting rid of those spaces without going through every line of the resulting text file? Thanks!