Convert multiple records per ID into single ID record with multiple columns

[zmbd]

basically... yes a quick SQL wouldn't be bad.

As for the few I have tried in the past, I've done the same thing you do, use the wizard or find something "close enough" online and set the ax to it too :)

-z

[zmbd]

If the cross tab query doesn't work... using your posted example data, I have solution using vba that seems to work. It's a variation on a theme I was working on for a project for an equipment-id creation on a report.

-z

[zmbd]

@nowthatsaplan
hey... how'd this work out for you?
-z