Search results for query: *

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

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

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

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, how do I get a param to the query form the...

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, how do I get a param to the query form the...

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

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

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

I have a report that is like a spreadsheet... See screenshot at: (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 view for each cell so I fifgured I could just put a...

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

Is there a way to set an execution order of report elements in an Access report... I have an Access report and have a top section that must execute before the bottom section does... Each of the elements (in all sections) are making calls to functions and typically passing paramters to those...

Need some help..... Order of functions executed in Access? Have my control source calling the 2 'calculating Total' functions at the bottom to populate total current year & Next Year's HOURS...... (not sure how else to do this).... I would think this should work only because the main function...

I need to somehow be able to get path of Db file at current location and dynamically insert it into the path source.... How do I do this? Orig: sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\MyName\My Documents\Blue&White.mdb;" New: sConnString =...

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

New to VBA....quick easy ? I'm sure... I have three variables (at the bottom of the function) [CurrentRate][CurrentRateStDt][CurrentRateEndDt] I would like to be able to pull each of these different variables into a different place in my report via the control source.... how do I do this? Thx...

I have a function with the following SQL string that is not executing properly in the module... I can pull back the proper results with a query but when i try to properly translate it in my SQL string in the module... I keep getting various errors.... Can someone look at this and tell me how...

Can I Display a Qry output as a Header Rows and then.... Cross-ref people against those header Rows...? I have a master Email Distribution List (~15 diff lists).... need to display those dynamically as headers (horizontally) and then show the people as Rows and notate (x) if each person...

Can I Display a Qry output as a Header Rows and then.... Cross-ref people against those header Rows...? I have a master Email Distribution List (~15 diff lists).... need to display those dynamically as headers (horizontally) and then show the people as Rows and notate (x) if each person...