Search results for query: *

Thanks lynchg for your speedy response! I tried it and the query seems to return everthing that that person was assigned for the day. It does not seem to be returning just the assigns that have no corresponding completes. For example user 1490 was assigned for 12/12 lets say 25 of survey type 1...

Hello, I have two tables one called assignments and one called complete. The fields in Assignment are id asdate park survey assigned loaddate The fields in complete are id codate park survey completed loaddate The purpose of the report is to find out what someone was assigned versus what they...

Thanks dhookom and ProgramError works like a charm!

Thanks ProgramError. Actually the date field determines the shift. The problem with using the date is I can't just go back 20 days since a worker may not have worked 20 consecutive days. My fields in the percentage calcualte query are, userid, sumofassigned, sumofcompleted, percent (which is...

Thanks for your answer. Is there a way to do this without vb? If I query my database for userid 1200 to return all of 1200 records ordered from latest date down, how would I extract just the latest 20? Can I do this without creating a new table just outputting it to a report.

I am trying to create a query that will return the last, meaning by date from today back, 20 entries for a particular user. I can not just go back 20 days from today since the user may not have worked twenty consecutive days. What do you think is the best way to accomplish this? Thanks in advancec

I have been tasked with creating performance reports. We are tracking performance of work completed vs. assigned by user id. I have gotten to the point of being able to generate a percentage by simple math. The part where I am stuck is they want to go back just the last twenty shifts and if...

Thanks Zeroanarchy, I think the proplem was with the page setup. For some reason it lost the layout for the labels, as they were all reset while the new report had the correct layout settings. Hopefully it will retain these settings that I manually entered. Sussex

Zero Anarchy. It appears both on screen and in print. I have a macro from a switchboard that prints the labels automatically when pushed not going to a print preview. The label is in the detail section of report. It was all setup by the so-called label wizard. Again it seems to occur after the...

I have set up a report using the Label Wizard in Access 2000. I select Avery 5160 which is 3 across. After the fourth or fifth time I run this report some how all the address get pushed to the left most column and are mis-aligned in that one column, meaning pushed down by one line and printing...

I work for a hospital. The problem is we want to calculate the difference between the Sign in Time and the Appointment time. Here's the problem. Some people arrive prior to there appointment time and some arrive after. I want the average of both, but, I can't seem to get access to work with...

I have a database with 6 time fields T1,T2,etc. How can I get the minutes between t1-t2,t2-t3, etc and then average them for a specified date or date range.I do have multiple times foor any given day This has been driving me crazy and I know the answer is right under my nose. Thanks