Search results

You are amazing!! Thanks for your help!!

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.

What I've done so far from your instructions. I so appreciate the help and I'm learning a lot!

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?

Thanks so much!

I just reposted in new thread.

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...

Thank you for designing that for me. Looks like exactly what I need!

Thanks for your feedback.

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).

You have made my day!!!

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).

I am not a programmer and assume this needs some coding. But if there is a way to run a query please advise. ScreenIN and ScreenOUT amounts are entered. ScreenINDiff is the difference between the current date ScreenIN and the previous date ScreenIN Same with ScreenOUTDiff (difference between...

I'm excited to join this forum in hopes of getting a big of help from time-to-time. I enjoy using Access but can get easily frustrated not knowing how to program. I'm trying to learn but it's slow going!!