Search results

Perfect! Thanks.

Hello Can someone help me with this Switch()? The query runs but the result is not right. I want to group a date column (2009) into quarters. Below is one for quarter 3 for April, May June. The date column (2009) has m/d/yyyy format 2009_Q2: Switch(Month([TimeWriting].[2009])=4 Or 5 Or...

Thank you Bob.

Hello, I have a report based on a UNION query. The report has DSum() and DLookup() functions. The query works fine, but when I run the report it just hangs on "Formatting Page press Ctrl + Break to stop". Cheers for any help!Thank you.

Thank you!!

Please, can some one please tell me what’s wrong with my DSum function? =DSum("[AprilVCOS]","VCOSmaster","[D_Level]<>'H.SCOTT'AND 'SurtiVacCalaDB'”) -- this excludes “H.Scott” but includes “SurtiVacCalaDB” =DSum("[AprilVCOS]","VCOSmaster","[D_Level]<>'H.SCOTT'AND <> 'SurtiVacCalaDB'")...

Thanks for your advice! The value is zero because I deleted the tables with April and May numbers to reduce the file size to be able to send it. Otherwise it will never be zero. I agree with you on the hard-coded dates but have no clue on how to do that!

Thank you for replying. Please can you direct me on how to do that? Do I create the query with option of selecting a director in the report? I do appreciate your time.

Paul, both reports are opened. No subreports involved. The DB has sensitive company info. I don't think I can post it.

Yes boblarson, I had: =[Text29]/Reports!VmSouTotal!Text20 but did not work.

No Paul, it did not work. Thanks.

I tried with the other report opened but it returned “#Error” value. Here is the formula in the Expression Builder: =Text29.ControlSource/Reports!VmSouTotal!Text20.ControlSource Your help is appreciated!

Hello, I have a query with revenue data grouped by month and by director. I’m building reports for each of the director. I don’t want run separate queries for each of the directors because some of the director’s revenue is spread among other directors based on a certain percentage. I want to...

I have an unbound field in rptMonth whose value is calculated based on total revenue for a month (in rptMonth) divided by total rev. for the year, which is in report rptYear. In the control source I have: =(Sum([APRILREV])/(Reports!rptYear!Sum(REV))) The report asks for parameter value for...

MS Access 2003 I have a table with data grouped by month, by P&L (which is Rev or Cogs), by customer and by director. The field names are “calendarMonth”, “Rev”, “Cogs”, “Customer” and “Director”. Five columns total. So, January’s data is first then February’s, March…..etc. I’d like to have...

Thanks again.

Many many thanks JR, Since I'm appending from 12 link tables; one for each month, do I need 12 append queries to fill my table or there is a better way around it?

Thank you.

Thanks JR. Can I use a Macro to delete data from the REV–COGS Table and and re-append to this table when reports are run?

Hello Can Access populate monthly column heading(January, February,….December) base on date in, for example a “Calendar Date” column (with dates) or I have to Switch or if statement to manually do that? Many thanks for any help you can give me!!