Search results for query: *

Ok ended up with TRANSFORM Format(nz(Count([Application Title and Key].[Assessment Type])/[TotalCountOfAssessment Type],0),"#,##0.0%") AS Expr1 SELECT FinancialYearDateRanges.FromDate, FinancialYearDateRanges.ToDate, Count([Application Title and Key].[Assessment Type]) AS [TotalCountOfAssessment...

Ahh Ok I was looking for a query way to do this. I am assuming your post means there is no way to do it. As report formats etc change but if I have the data in a query I can recreate it in multiple "styles" to suit the whim of the executive and committee

Is there a way to make this calculate percentages not counts based on total for each row

OK I went back to my orginal code before using the form process to check it still worked now that I have moved to the real database and now it won't work it says Undefined funtion "format" in expression. Maybe this is the cause of the form to report process failing PARAMETERS [Enter Start...

Thank you SOOOOOOOOOOOOOOOOOO much I even understand what you said and can now go an create the other 6 of these I need !

Ok I have TRANSFORM Count([Application Title and Key].[Assessment Type]) AS [CountOfAssessment Type] SELECT FinancialYearDateRanges.FromDate, FinancialYearDateRanges.ToDate FROM FinancialYearDateRanges, [Application Title and Key] WHERE ((([Application Title and Key].[Application Eligibility...

Ok I created a new Table "FinancialYearDateRanges" and then created a query "YearCrosstabSource" with the Fields from that new table and the table above "ApplicationTitleandKey", so that I would have a single query with all necessary colums to make my crosstab. However I am not sure how to get...

I have a query regarding getting only partial data in a query SELECT [Application Title and Key].[Application Assigned Number], IIf(IsNull([Suspension total days per assessment].[No of days assessment suspended]),0,[Suspension total days per assessment].[No of days assessment suspended]) AS...

The table has the Fields ID (this is the primary key) Assessment_Assigned_Number Assessment Type Date_of_Application Funding Recomendation or Advised Etc

I need to break down data such that it performs a count of one field but based on a date field I have a table with Fields ID (this is the primary key) Assessment_Assigned_Number Assessment_Type Date_of_Application Funding_Type Etc I need a report which says Etc Date range Assessment type 1...

ok back to basics I have several crosstab queries which recalculate based on a date range eg PARAMETERS [Enter Start Date] DateTime, [Enter End Date] DateTime; TRANSFORM Format(nz(Count([ID])/[Total Of ID],0),"#,##0.0%") AS Expr1 SELECT [Application Title and Key].[Assessment Type]...

Ok No worries and THANK YOU I am trying to produce a number of reports from a tables which largely contain dates The reports are counts and percentages in both cross tabs and straight queries I am hoping to use a form fo the user to select the date range and then either buttons, or better a...

I have multiple cross tab queries for all of which the output results are defined by a date range. That is the cross tab recalculates based on the date range. I am trying to generate one / or many reports and put the dates in through a form. So far I have the query structure working fine eg...