Recent content by 510sx

ya, got it working... like you said using two queries Is it possible to combine two queries to one? SELECT PalletData.ProductCode FROM PalletData GROUP BY PalletData.ProductCode, PalletData.PalletTagNumber HAVING (((PalletData.PalletTagNumber)=[])); SELECT...

I use running total before and I don't see why it would apply to this problem. Anyways, I will look it up some more. It's a good start. Thanks John

Like I said it just a simple select query Select ProductCode from ProductCode where PalletNumber = 23456 usually it returns 1216 1216 1216 1216 . . . but sometimes it returns 1216 1216 1216 1216 1224 1224 . . . I need to build a query that detects the PalletNumber contain more than one...

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

I've tried that, but it returned all the records. Then I deleted the dateTime field, it returned the avg of the entire temperature record. I am expecting to see one average temperature per day.

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

Thanks for the sample, Chris. I modified my query using your method, it did print the way I want it. However, like you said the second list will print at a position depending on the length of the list. I am using perforated paper, so the second print has to print right below the perforated...

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've thought about using Min/Max, but I could see a pontential issue. if there is a record reads 0, then my min would be 0 within the datetime range. I haven't tried to use min/max on my date time stamp column, though.

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