School assignment, have everything filled in and done, just need to know how to do one last part.
I need it so items in the first column, dont repeat, and are left bank. It's sorted in ascending order by the first column and it needs to be so the the first occurance of text in that column is listed, and the the repeats are blanked out. By blank out I mean just the first column in the row, the rest of the row has to display. I hope I explained that clearly. Teacher's handout said this was possible, but I must have missed it if he said how to do it.
Thanks for any help
Edit: forgot...this would be done with a query
NM, This can be deleted, found what I needed by making it a report.
I need it so items in the first column, dont repeat, and are left bank. It's sorted in ascending order by the first column and it needs to be so the the first occurance of text in that column is listed, and the the repeats are blanked out. By blank out I mean just the first column in the row, the rest of the row has to display. I hope I explained that clearly. Teacher's handout said this was possible, but I must have missed it if he said how to do it.
Thanks for any help
Edit: forgot...this would be done with a query
NM, This can be deleted, found what I needed by making it a report.