how do I put a blank line between rows

[Afrosheen]

I have a report that display the same fields but with different information.
For example:
a-days
a-days
b-days
b-days

and so on and so forth. Here's what I want to do.
a-days
a-days

b-days
b-days

and so on. I want it to skip a line where there is different information. I
know I have to program a chr(13) or chr(10). I just don't know where to place
it, Don't know how to write the code.

I've only worked with Access about a month, so any help would be great full.

Is there a way I can put that in my report?

Thank you,

PS: Sometimes this message works for me other times I try and give a reply
and I t takes me right back to the message board. Don't be affended if you
hear nothing back.

 

[Al Campagna]

Afrosheen,
Let's say that field is called DayType
Use Grouping and Sorting to establish a group on DayType.
Open up a space In the DayType footer.
That will insert a vertical space at the end of each DayType group.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[KARL DEWEY]

Must be a class room project. Tood asked the same thing in the Queries
newsgroup -- Group by week with a space.