Search results

  1. R

    VB Module 101 ?...

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

    OK.. Simpler question

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

    Another complex(?) DCount Question...

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

    if DCount works to get count, what simple function call can I use to get ...??

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

    Can I ...... Should I... SQL Statement in Control Source of a Report

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

    Date Format.... How Do I..?

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

    Execution order in Access report? .. HELP (Long Read)

    (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...
  8. R

    Determine month's of report cells to add to calculation

    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...
Back
Top Bottom