The rptLabels report starts printing in upper left corner. I'd love to be able to decide what position to start my label so I can use a label sheet that has been partially used.
Oops, I just realized another problem. When I run the report (rptMeters) based on qryMeterDiffHider, it won't show ScreenInDiff, ScreenOutDiff, MeterInDiff, MeterOutDiff. Why is this?
When I try to create a report from my qryMeterDiff, I get the "Multi-level GROUP BY clause is not allowed in a subquery message." I'm pretty sure it has to do with the calculated fields in my qryMeterDiff (ScreenInDiff, ScreenOutDiff, MeterInDiff, MeterOutDiff). See rptMeters.
Thanks for the info. I'm new to the Forum and was wondering if I needed to start a new thread or not. Will do that. You are correct in regards to the point of the ScreenIn/Out/Diff and MeterIn/Out/Diff. Basically the differences of the current compared to that last meter readings should be...
I'm having the same issue. When I try to create a report from my qryMeterDiff, I get the "Multi-level GROUP BY clause is not allowed in a subquery message." I'm pretty sure it has to do with the calculated fields in my qryMeterDiff (ScreenInDiff, ScreenOutDiff, MeterInDiff, MeterOutDiff). See...
I have a form with a subform which also has a subform. I want them all to be set to Continuous Form. I had it all working and then messed it up. Tried to recreate but can't get the main form (frmMeters) to show the records. It will show the records if I delete its subform (frmMetersSub).
Yes. I guess I need more help with this than I first thought. I want to run a report based on the Asset# that will figure the difference between the previous date's ScreenIn and the current date's ScreenIn and do the same for MeterIn and MeterOut. Then I'll compare the difference between the 2...
I'm attaching the database. I added the above code to Modul1 but am pretty clueless as to the best way to get it to work with my tblMetersTest. I think once I understand how the code works for ScreenIn/Out I can then create the one for the other 2 fields (MeterIn/Out).