retreiving one field repeatedly in cross tab style report

[Eyor]

Yet another Newbie to Access. I need to create a report to verify data entry accuracy. To do this I think I can either:

1. Retrieve a single field multiple times in a Row, like so:

Result1|SigFigs|Result2|SigFigs|...etc.

The results are stored in a single field called results. I have created a cross tab query to get the different results in one row but, this ends up grouping the results by the number of sigfigs. Sorry I don't know the syntax but, is there a way to do something like this:

foreach result get sigfigs and display as new column heading

Or better yet but probably non-trivial

2. Combine result and sigfigs to return a result with the correct number of sigfigs

Hope someone can help with this.

 

[Eyor]

Looked at another thread and found that solution 1 can be accomplished simply by joining the two field together. So, looks like I have a solution, thanks forum!