Hi. so i'm using ms access 2007 as a database, i have here a table of TRANSACT IP which has the following columns of
Transact_ID, IP_ID, Date, Time, Average, Min, Max.
i have to produce a report in which i have to query from this table with the follwing format:
Office, IP_Address, 8:00, 8:30, 9:00, 9:30, 10:00, 10:30, 11:00, 11:30, 12:00, 4:30
-the columns of time between 8:00-4:30 should contain the average from the Transact IP table
dpending on the Time that the IP_ID had been pinged which can be determine by the Time column of TRANSACT IP table.
How can I be able to do this and produce the report with this format. thank you so much :)
