Recent content by mistahpat

I've used, CDate(Int([time]*48)/48), and that seems to be working! Not sure what might not, but I guess I'll cross that bridge if I come to it. =)

Thanks for your response/advice. I need it rounded down. I am going to try to implement something you've stated here, but as I'm new, I may end up with more questions. Lol.

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?

Oops. I should have stated: I'm using the CallsOffrdNGCC_pat query.

Here is the DB.

I really do appreciate your help, so thanks again. I may have to leave here shortly so will probably have to pick this back up tomorrow morning. As far as the uploading, I'd be happy to - though, does this site allow that? I don't have a repository for myself.

SELECT PSGDataExtract.Date2 AS [Date], PSGDataExtract.Time, IntervalDim.IntervalStart, PSGDataExtract.[Call Type], IIf([Call Type]="Outbound Call",1,0) AS Outbound, PSGDataExtract.Group, QueueInfo_pat.Function, QueueInfo_pat.Department, PSGDataExtract.Queue, QueueInfo_pat.Language...

The date criteria is on the table DataExtract, which has the records for all calls. The QueueInfo table is just there to add more information to queues for reporting, etc. I need a certain set of records from the DataExtract (which is the table with blank entries in the queue column.) I think...

I am using: >=#5/1/2011# to get records from May 1 to date, but after using the outerjoin, I recieve records back to March. Could this be affecting my query somehow?

That worked. Thank you!

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