Report Header Problem

[brnkstyle]

I have a report where it sorts jobs assigned to a specific machine and that all works well but...a job can have 2 machines and i have the feilds set up so that machine one is in one feild and machine 2 is in another...so is there a way to put the second machine in the sort so if job 1 uses machine A and Machine B then the sort with show Machine A has job 1 and Machine B has job 1 as well

[MMcCarthy]

I have a report where it sorts jobs assigned to a specific machine and that all works well but...a job can have 2 machines and i have the feilds set up so that machine one is in one feild and machine 2 is in another...so is there a way to put the second machine in the sort so if job 1 uses machine A and Machine B then the sort with show Machine A has job 1 and Machine B has job 1 as well

You haven't given enough information about the structure of your tables or the sorting and grouping on your report for the experts to try to answer your question.

[brnkstyle]

my table has a feild for machine 1 and a feild for machine 2
each job can have either machine 1 or machine 1 and machine 2
in the report it sorts by just machine one
how do i get it to put the machine two in the sort as well

[MMcCarthy]

my table has a feild for machine 1 and a feild for machine 2
each job can have either machine 1 or machine 1 and machine 2
in the report it sorts by just machine one
how do i get it to put the machine two in the sort as well

You need to restructure you tables.

Machine1 and Machine2 shouldn't be two separate fields they should be a separate table. Have a look at this tutorial

Table Structures and Database Normalisation