formatting

[lee]

hi

i have data like this

city state city1 state1 cost
detroit mi bos ma 21
miss ma bos ma 22
newyor ny det mi 27
newyor ny det mi 29
san fran ca det mi 31


i want to add a line seperating the data wherever the col state1
changes.. for example after 2nd row of data and after 5 row of
data...just for better formatting data .. can you pls suggest how to
do that in access .. data should like this finally

city state city1 state1 cost
detroit mi bos ma 21
miss ma bos ma 22
----- one line---
newyor ny det mi 27
newyor ny det mi 29
san fran ca det mi 31
--- one line


thanks much

 

[SoftwareMatters]

Is this in a report?
If so you can do this with grouping by grouping on the state and adding a line in the group header or footer.