Search results

Again, I am new to Access. I have a table of call data with timestamps such as: 12:07:14 PM, and wish to translate that in my query to a corresponding 1/2 hour interval. So for each record in the query results, I should be able to see both: 12:07:14 PM and 12:00 PM. Is there an easy way to this?

I am new to Access and have been given a newly created DB to handle. There is 1 main table (..DataExtract) which consists of a data dump from a server and one of the columns is for queue names. However, not every record is populated with a queue name - many are blank. But those records are...