Recent content by mattbrem

Combining two queries and joining them worked, thanks! I actually had this as a report already, but when I export the report to excel it doesn't copy over any summation information because I was doing the calculations in the report itself rather than the query.

Sorry I am new at this. You want me to put Team_Total : Sum(1) in the qdg? That gives me the total for each person again, not the team total, or am I doing that wrong?

It says the expression is typed incorrectly, or is too complex to be evaluated. Here is the sql I used, did I put the field in wrong? SELECT tblInterviews.[Revenue Specialist], Avg(tblInterviews.[Interview Length]) AS [AvgOfInterview Length], Count(tblInterviews.[Interview Length]) AS...

I have a query that takes in two dates, start and end, and a team as parameters. It calculates average interview times, and total interviews grouping by each person in that team. I would like to add a column at the end that shows the total number of interviews done by the entire team. Output...

I have a report based on a query that requests two dates as criteria, start and end. THe query pulles records from my table that fall between those two dates. In my page header I have a textbox that I would like to count the number of records pulled by the query, but I don't want all of the...

I have a query I need to design and I am having a bit of trouble figuring out how to do it, my access skills are not my best. I have a table with several fields, but only two are relevant to the query. The first is a case number, and the second is a date. Some records have the same case number...

Just out of curiosity, do you know if your file server is running with oplocks enabled? I had a similiar problem with a split database I was developing. After pulling my hair out for weeks I found out my corrpution issues stemmed from our novell server enabling opportunistic locking. MS access...

That was all it needed... thanks a ton!

Hi, I have an unbound form with a subform that is linked to a table called Master Table. The subform is just a datasheet view to look at records. I have controls on the main form that should allow the user to enter the last name of someone and when they click search the form filters the...

Would it be possible to write some kind of vba script which looks through the table, counts the number of unique employers, and then generates and prints a report for each?

I have been asked to come up with a solution for printing a batch of reports. It would work like this, there would be a table with employer names along with employee information. The process should cycle through all the employers and group all of the employees belonging to an employer on a...