Millard Barrera

example:

have this;
beatles album 1
beatles album 2
beatles album 3

want this;
beatles album 1
album 2
album 3

and so on.

i need to know how to write an expression that would print artist name once if there were more albums by the same artist.

like: if artist is equal to prev.artist then print “” & album else print artist & album

i hope i’m explaining this right.

You’ll need to make a Query that GROUPS the data from your table.
The “GROUP” function is on the toolbar when looking at the Design view of a Query (it looks like a sideways “M”).

You can print the results directly from the query, but for prettier formatting I would suggest build a REPORT that drives off of the QUERY.

Check out the Microsoft Knowledge Base, You can download a sample DB “Northwind”. It has walk-throughs for doing all of the neat stuff it shows off.

100ml rare
sizzle choker neck scrunch
model motoring curves
jake reed
rialto venice

Trackback URI | Comments RSS