Recent content by rdjohnso

Pat, I wish thaT were true, but its alot more complex that just a simple query.... have to bounce against a DeltaDays() function to determine total working days within a month.. then determine total hours and cost based upon a person's Allocation and Rate given the time span they are alloted at...

Still very new to this VB Module coding thing.... need point in the right dir. I have a report with a need to populate a grid of information using 2 other modules I've written.... Goal: I need to cumlitivly get totals per month of persons hours and cost grouped by organization.... I have a...

OK.... not sure I understand.... maybe If I make it a simpler and shorter ? 2 part question.... I have setup a Query: "rdqry_AvgRate" screenshot at: http://www.lnrconsulting.com/misc/Query.jpg Question 1) in the query I am requiring a parameter "[Org]" Can I pass this param in my lookup in...

OK.. Simpler question on DCount / DLookup..?? 2 part question.... I have setup a Query: "rdqry_AvgRate" screenshot at: http://www.lnrconsulting.com/misc/Query.jpg Question 1) in the query I am requiring a parameter "[Org]" Can I pass this param in my lookup in my cell property. If I cant...

Better yet.... Heres one Query..... With TOTAL as my needed value to display for the cell in my report SELECT Count([tbl_Person.personID]) AS PersonCnt, Sum(tbl_PersonRate.Rate) AS RateSum, [RateSum]/[PersonCnt] AS Total FROM tbl_Person INNER JOIN tbl_PersonRate ON tbl_Person.PersonID =...

I have a complex situation I need help on.... My Goal: Avg Rate = RateSum / PersonCnt ...based on given Org.. like (GWHIS) and make it work in cell of a report.... will be switching out the Org's And here are the queries that make up the parts..... RateSum: Sum of Rate where Date()...

Thanks for the response Pat.... I understand and will use the Date(), makes sense..... Forgive me for my scrap at this.. still new at alot of these other functions. Thx

someone else offered this suggestion.... =DLookup("[ForecastAmount]", "rtbl_Forecast", "[ForecastTitle] = Software Licences AND [ForecastTimePeriod] = 3/1/2006") would something like this not work? it gives me an #Error right now.... *************************************************** This...

*** Further Clarification... I am trying to avoid having to call functions... just want something like the DCount that I can put in the ControlSource for each cell needed in a report....

Got this from someone else to tell me how to get a count of a group in a certain period of time.... NOW =DCount("*","tbl_Person","Now() Between StartDate And EndDate And GroupType='GWHIS'") ******************* if DCount works to get count, what simple function call can I use to get a record...

Someone else suggested I do it this way.... =DCount("*",tbl_Person,"Now() Between StartDate And EndDate And GroupType='GWHIS'") Unfortunately.. I am still getting the notorious... #Name? error.... any idea why?

I have a report that is like a spreadsheet... See screenshot at: http://www.lnrconsulting.com/temp/ResourceRpt.jpg Here (I know it looks like Excel... but has to be like this...) Each cell has a diff equation based upon the data in the tables... (I didnt want to have to build a seperate query...

I did that but doesnt make a difference..... this is a weird one.

Thanks a bunch Andy... that is very close to what I need.... Here's actually what I Put in.... ="January" & " " & Format(Year(Now()),'yy') Weird thing is.... when I do a preview for the report.... it says January 05... not 06... and Yes I checked and my computer IS Feb06 so its not that...

I have a report where I am trying to make the headers Jan - Dec of Current Year.. so the first coloumn header should show: January 06... but the '06' needs to be dynamic in the se3nse that next year it should show 07. Anyone have an idea how I can do this in a single cell? Thanks in advance...