Search results

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

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

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

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

I have a query which contains 3 tables and I am running into a problem where the query eliminates data that isnt included in one of the tables that I have linked. I tried changing the relationship link so that it would show everything from the one table and the fields from the other table that...

I am getting an overflow error when I try to perform a calculation in a query. There is dividing by zeros, so I do have #NUM errors in this field. Can I write an IIF statement to ignore the #NUM? Right now my IIF statement reads as: IIf([Quality Success Ratio]>=0.8,"1","0")

I have a query (qryStackRank) that I would like to assign a ranking number to based on two fields. There is a Full Matrix Rating field and if there is a tie, I would like the tie to be determined by the number in the Overall Stack Ranking field. I have been reading about using Select Count(*)...

I have two fields in a query that I would like to include in an IIF statement and I keep getting #Error. Here is what I have tried. (The first field is a position ranking field and the second is an attendance field) IIf([Position Ranking]=4 And [Attendance Rating]>=2,"2","1") What is...