Search results

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

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.

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'")...

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

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

Please Help!! I have a linked table that I’d like to append data from excel spreadsheet every month. Is this possible? For example, I have a linked table (REV–COGS Table) with January data. I will like to add onto this table February’s, March’s April’s…..December’s data by link tables so...

Hello All- I am using a union query to sum the result od 2 queries. the query asks for "parameter value" when run. How do I solve this? Please help. Below is my code. Thanks all. SELECT [Delivery Org], Sum([SumOfCY10 Q1 TOTAL ACTUAL]) AS [Q1 ACT], Sum([SumOfQTR 2 FORECAST]) AS [Q2]...

Please- I have a field with revenu and cost of goods sold amont called "Total Local Currency Amt" and another field called "P&L" with values "REV" and "COGS". I want to split the the "Total Local Currency Amt" into 2 columns; Revenu and cost of goods sold depending on the value (REV or...