Search results

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...

(Issue explination at bottom) Code: Option Explicit 'Get Total running Hours for currentHours and nextHours Public mHPersonID As Integer Public mTotHoursCrtYr As Long Public mTotHoursNxtYr As Long 'Get # of Allocation records for a PersonID 'passed in' Public Function PersonHrs(PersonID As...

I am trying to populate these four cells in my report.. from the monthly cells above... but based upon if it is the current year or the next year... Screenshot The Monthly Hours and Cost are already calculated via a Function.. so I am unsure how I should do this.... I would typically do...