Search results

Hi, I have a simple SELECT query that returns a set of ProductCode based on the PalletNumber I enter. 98% of time the ProductCode are all the same, which is expected. Sometimes (2% of time), it returns the expected ProductCode and other Product. I like to come up a query to check the result...

This may be a good problem for the experts here. I am trying to write a query in Access to populate daily average temperature of the pass few days (the date range has to be dynamic). Lets say I have a table storing the temperature every hour and I want to know each day's average. any suggestions?

I created a bat file to trigger the MS Access report and auto print. we usually print out the same report 200 times a day, and we see the same error about 10-15 times a day. I have no clue what causing that. The error is "A custom macro in this report has failed to run, and is preventing the...

I created a report. This is a dynamic report and it is about printing the product code and serveral manufacturer information. You enter the product code and it returns a list of manufacturers. This report takes up the upper half of the paper. I would like to have it duplicate on the lower...

I think I spent enough time for this problem. I feel like I am spinning the wheel and getting nowhere. I hope you guys can help me. What I intented to do is to query how much water pumped out of each pump within a given datetime range. Pretty simple right? You take the last record minus the...

I thought I could figure it out by myself, but after I spent a few nights, I am kind of exhausted. I created a report and dragged to my c drive (c:\myreport.mar). If I double click the mar file, it will display the report nicely. My main problem is; I need this report to be executed 3 times...