Search results

Thank yo so much for your help, it's working now.

This is the query; SELECT txt.Date, Format([Time],"hh") & ":00:00" AS [hour], Avg(txt.[Pressure bar]) AS [AvgOfPressure bar], Avg(txt.[Temp C]) AS [AvgOfTemp C] FROM (SELECT * FROM [TEXT;DATABASE=C:\Users\abdurrt01\Desktop; HDR=Yes].TG-324z_RAW_All_20220101_20220131.txt) AS txt GROUP BY...

Good Morning CJ_London. Thank you so much for your answer. But unfortunately I am not getting my results, I am not very expert user of access so may be I am doing something wrong. So the situation is that I have already created a table in Ms Access and imported all the data into that table which...

Hi, Thank you so much for your prompt reply. Please find attached the sample original file (as this file contains the date for each second so the file size is to big) I have just copied some of the records. Two other files are the expected results. Please let me know if you need another information.

Hi Everyone, I am looking for a query to generate the daily, hourly and monthly average. I have a table with columns Date, Time (hh:mm:ss), Pressure and temp. in the Time column I have data for every seconds for some days and every 30 second data for some days. I want to generate a query which...