Search results for query: *

ok so I thought I would change it up.... something more literal using the strMonth from another field. Anything obvious I am missing? =DLookUp("[OrgCosts]","rdqry_AllocatedOrgHoursRatesPerPeriod","[Organization] = 'Daou' AND [strMonth] = 'Jan'")

well this doesnt even work... =DLookUp("[OrgCosts]","rdqry_AllocatedOrgHoursRatesPerPeriod","[Organization] = 'Daou'") it would bring back about 5 records so thats probably why this doesnt work....

tried both... what am I missing? =DLookUp([OrgCosts],"rdqry_AllocatedOrgHoursRatesPerPeriod","[Organization] = 'Daou' And dtmStart Like '1/*/" & Year(Date()) & "'")

you got me Zion.... the 'Daou' part works but guess the other 2 parts dont work.... the values of 'dtmStart' example: 1/1/2006 I need to get the record where the month of dtmStart is January or 1 AND year of dtmStart is currentYear.(2006) R any other ide

thanks Zion... I tried that but it didnt fix it.... R

Here is the code: =DLookUp("[OrgCosts]","rdqry_AllocatedOrgHoursRatesPerPeriod","[Organization] = 'Daou' AND Month([dtmStart]) = '1' AND Year([dtmStart]) = " & Year(Date())) The Query is pulling data from another query.... but the names of the fields are exactly as shown.... The query...

MajP.. you repliesd to me but didnmt give me an alt email addy... Pls do, Thx Ron

MajP. I am trying to reply to the email u sent me and it gets bounced... do u have another email address that u can send to me so I can respond? Are you avail via IM to chat? Thx for ur help, Ron

What I have.... =TotalResourceCost("GWHIS",#1/1/2006#,#1/31/2006#) What I need.... =TotalResourceCost("GWHIS",A1,B2) A1 - should be 1st day of Jan, CurrentYr B2 - should be Last day of Jan, CurrentYr Ideas? Thanks for assistance

PS... Email me if your willing.... lardj2332 <at> adelphia.net.... Are you avail via one of the IM Services? If so, which?

OK Majp..... here's the big ?... It looks like the data is correct, super thanks... I have to call these queries in my control Source for each cell... so if you go to the following Report..... 'Grpt_ResourcePlanning' you will c the cells I have to popuate a cell for a specific group for a...

wow, had no idea you would put in that much effort..... thanks a bunch... will give it a try... R

did you run it against those functions or is this just a sumnation of total hours grouped by organization?

ah.. that makes sense.... one half dozen or the other... guess your way makes more sense. Thx, Ron

very interesting.... the value I get running against my piece is the same value.... what I dont get.... ia how the DAvg() function knows to calculate the Rate / PersonCount

Little variation .. but it finally worked.... Thanks a bunch Ron

thanks Majp.. hope u can too.... http://207.195.226.110/lnrconsultingCom/htdocs/misc/BlueWhite.mdb The Module I am working on is called: mResourceInfo In it, I need to call the other functions in the other modules... mPersonHrs & mPersonCost... Thx for willingness to even look.. Ron

here's the Db in case u want to look at it... http://207.195.226.110/lnrconsultingCom/htdocs/misc/BlueWhite.mdb

if willing, I will post the Db on my server and provide a direct link to the file... LMK Ron

snyper... I get the dreaded ''Organization is not part of an aggregaite function error' using the SQL Statement you provided... I playeed with it for awhile but to no avail... ideas?