Search results

sorry for the confusion, I was actually asking a question: would it be possible to have just the report open in a maximized window while a form is open minimized?

Would I use a similar technique from 1 record in a form to a doc in MSWord?

How about having only the report open in a maximized window if the rest of the database is minimized?

THANK YOU THANK YOU THANK YOU!!!

Perfect! That WHERE function is what I needed. It works like a charm. Thanks! But now I come to another tie-up: When a counselor is hired they are part of a training unit. When they complete certification (6 months) they switch to a regular unit. I'm using 2 tables; the above table (called...

Table is called PHONE MONITOR. Field names are: MONTH / COUNSELOR / CONNECT / PROTECT / RESOLVE / CPRID (autonumber). There's an average of 10 monitors done per counselor per month. Connect/protect/resolve are numbers from 1-5 with 5 being the best. Another problem is PROTECT doesn't always...

Anyone know how to calculate an average by choosing a number in a field coresponding to the month of the year? I have an average for year-to-date, but as soon as I add in a month, it'll list all averages for each month, and not the year-to-date. HELP!! This is the only thing holding me up on...

I have a table name PHONE MONITOR joined to a table called MONTH. I have a query returning the average of PHONE MONITOR. How would I do a create a query that calculates the year-to-date average of PHONE MONITOR. I know how to do it in excel, but can't figure it out in Access 2k. If I were...