Recent content by dbaker5204

Thanks, that was it! No clue how that would have gotten turned off.

When I try to add a subreport, the subreport wizard box does not appear. I have tried other reports in which it has appeared in and it does not and I have even tried other databases and no luck. Im using Access 2016

No, it does not. Which is weird because it worked yesterday and all the days before.

So I have a report that I have been running for awhile now and nothing has changed with it, this whole week it has run fine and today I get the following error: "The expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many...

I have never used a subquery before. Below is my SQL, what would I need to type: SELECT tbl_AgentSchedule.[Agent Name], tbl_AgentSchedule.[Start Time], tbl_AgentSchedule.[End Time], tbl_LogInLogOut.[Login Date], tbl_LogInLogOut.[Log In Time], tbl_LogInLogOut.[Reason code], tbl_LogInLogOut.[Log...

I have a query that produces login in times for our agents. On a normal day, an agent would only have 1 log in time, but due to phone system issues they may get logged out and have to log back in. Thus my query is returning 2 log in times causing an issue when I try to use the log in time for a...

Is the area I am pointing to in the attachment the right area? If so, when I type in "June", I get an error when I try to switch over to Datasheet view that says: "Scaling of decimal value resulted in data truncation"

I used a cross tab query for the main report as I was showing values month over month. I created a cross tab query with the Month to Date totals that I wanted to use as a sub report but I get an error that says "You cant use a pass-through query or a non-fixed column crosstab query as a record...

Thanks, that fixed it.

I have a query that is not grouping by Team. Currently it is grouping by Agent name, Supervisor, Date and it set to group by team, however, it is listing the teams separately. The Teams are linked to a table that lists the queue number and name, and the queue numbers and names are different for...

What was suggested in #9.

I got it to work, thank you!

Well they took calls, they just didnt log them...

So, there wont be a way to make it show that they still took calls? And just didnt log them?

This? SELECT tbl_MSP_Cases.[Agent Name], tbl_MSP_Cases.[Opened Date], tbl_MSP_Cases.[Case Number], tbl_MSP_Cases.Subject, tbl_MSP_Cases.Status, tbl_MSP_Cases.[Created By], tbl_MSP_CMS_Agent_Data.ACD_Calls FROM tbl_MSP_RepandSupNames INNER JOIN (tbl_MSP_Cases RIGHT JOIN tbl_MSP_CMS_Agent_Data ON...