Search results

Well on the form if I put the start date as today and the end date as today I get the technicians productivity for just today so I can determine the highest producer. If I put the start date as say Moday of last week and the end date as Friday of last week I will get the weeks highest producer...

Nevermind I guess I was making this alot harder then it needed to be. Ended up just making a form with a start date and stop date then put the date range as a where condition in the query. That works alot smoother.

The current day is what I meant by day Basically there are pay incentives tied to the highest producing tecnician. Incentives for Highest today, Highest for the week Highest for the month Highest for the year. The total cannot be tallied until there is a date complete in one or more of the 4...

I have a query that is based off of a union query SELECT clvpertech.clvtech1 AS Technician, Sum(clvpertech.CLVCode) AS CLVs FROM clvpertech GROUP BY clvpertech.clvtech1; This is returning a sum of all the procedures a technician does for the entire database. This is working. I need to break...

Wow, Thanks for the info. I think Im somewhere in the middle - I suppose I will start off with this and improve it as I learn more about it. It is a lot more involved than I thought it would be. Thank you for taking the time to explain that to me. Stay away from the sticky foods w/ that temp...

I got the omitting problem fixed with UNION ALL SELECT What kind of problems am I in for down the road pbaldy?? Is what you were talking about a bad thing or will I be able to go on?

hahaha Great, Thats what they get for getting me to make the database! Its for a dental lab - I make teeth for a living not databases You are right - in the end there will be 20 of these blocks because each project can have up to 20 different codes all done by a handfull of technicians But I...

ALMOST There I have the following two queries Query 1 SELECT case.clvtotal1 as CLVCode, case.clvtech1 FROM [case]; UNION SELECT case.clvtotal2 as CLVCode, case.clvtech2 FROM [case]; Query 2 (The one I use to see the results) SELECT Query1.clvtech1 AS Technician, Sum(Query1.CLVCode) AS CLVs...

Well maybe I dont understand Everytime I try to change any of the values it saves but then I get a warning saying Characters found after end of SQL statement. Basically the fields I need to work with are clvtech1 clvtech2 clvtotal1 clvtotal2 So it groups clvtech1 and clvtech2 together and...

Thanks KeithG I think it may be - just not the fields I need, I am looking into the qryALLCLVCodes query you wrote, Its all new to me but I think I am following what you did. Im going to tweak that a bit and see if I can get the technician fields in there so I know who did what. Will be back...

Well it seems to work sort of, The problem is I get 2 columns User A in the clvtech1 column and UserA in the clvtech2 column. Is there something that can be done to go through both fields (clvtech1 and clvtech2) get all the instances of userA from both fields then return the sum of the clvs...

Thanks for the fast reply, I will try that out.

Not exactly sure if a query is what I need in this situation or if it is what I need how to get there. In the attached db example on the case form there is a section for technicians to go in and take credit for steps that they performed as part of the overall case So clv1 might be done by User...

Solved! Here is what I ended up doing just in case someone else is going through it also. I got rid of everything listed above (The on load event for the form etc...) Changed the field in the table from a combo or list box to a text box On the form I added that text box Then in the text box...

Well after alot more reading I am thinking I am going about this all wrong. Queries are not meant to add info to a table thats what the forms are for But when the name changes regularly is there a way w/ access to do this dynamically or do I need to change the default value every time the name...

Well thats the problem, this name will change on a weekly basis. If you look at the tech form there is a department block. Every so often 1 of the technicians department will be changed to plaster bench. So the form for a Dr to initiate a new case will have the name that is associated with the...

Hope this works... sorry

Thanks Melaz29 Here is a slimmed down version (Mainly because the original has a bunch of junk since I am learning as I go but didnt want to get rid of anything just in case I forgot something along the way) but this is doing exactly as I described - If you open the form named case look at the...

Hi all, New to the board and access (2000) I have been tasked w/ creating a database to schedule and track incoming cases for my job (Dental Lab) This entire thing is new to me but have developed most of it through reading this forum so thanks for that! I still have a long way to go... Here...