Daycode - Row Heading - queryLME2 - groupby
Line - Row Heading - queryLME2 - groupby
Machine - Colomn Heading - queryLME2 - groupby
PlannedTime -Row Heading - tblProduction - groupby
Impressions -Row Heading - tblProduction - groupby
Sum of Time - Value - queryLME2 - sum
Total Of TtlTime: Sum([TetraLME2]![SumOfTtlTime]) - Expression - Row heading
LME Final: (Query) all data taken from the crosstab above
and so on.......
it all works fine UNTIL i put the date reference in, as soon as i use
Between [Forms]![frm_LME]![DateStart] And [Forms]![frm_LME]![Dateend]
it all falls apart on me and it stops.
Use a message box to display the statement that you are trying to use.
Then use your query and enter some dates into it. Look at the SQL statement that is generated and compare with your message box result.
You may have to concatenate some # signs in there so they will be referenced as dates.