Recent content by joshk6656

Well, I switched from a JOIN over to a subquery and got it working perfectly using the following: SELECT AuditLog.Processor, Format(CDbl(Date)-(Weekday(Date)-2), "mm/dd/yyyy") AS WeekOf, (Select Sum(ProductionCount.WeeklyCount) From ProductionCount Where...

I attached the database, also i included the 2 things i would like joined as seperate queries. input 06/2008 into the popup to see the results of the query. thanks for the help

I currently have a left join pulling data from a table inputted weekly with production of workers. I developed a new table which the workers process the claims, and it enters a entry for each item processed. I want to change over from the left join of the lump sum (entered by hand weekly)...

That would indeed pick a random 10 from the entire table, but I need to pick a random number for each processor

would anyone mind helping me with the query below. i am looking to pool a table and to pull a set number of records randomly for each processor. from what i am understanding, i need to calculate a rnd() field, then sort by that and use the top query, but i am having trouble. any help would be...