D
dbalorenzini
I have a report that returns stats for barriers that client have for services.
First you need to enter the date parameters for the report via a dialog box
That executes the report
The report is based on a query called qryClientBarrier below:
SELECT tblClient.ID, tblClient.DateOfIntake, tblClientBarriers.*
FROM tblClient INNER JOIN tblClientBarriers ON tblClient.ID =
tblClientBarriers.ClientID
WHERE (((tblClient.DateOfIntake) Between
[Forms]![dlgReportDateRange]![txtStartDate] And
[Forms]![dlgReportDateRange]![txtEndDate]));
The individual barriers for the report use the following DCount expressions
to get the counts:
=DCount("[ClientID]","qryClientBarriers","[bTransportation] =-1")
This is the contol source for each of the different categories of barriers
(unbound textbox)
The client now wants a change to the report to show the barrier with the
highes counts at the top and then descending after it.
So in this case
Low Math skills would be at the top
Transportation would be next followed by Child care and so on and so forth.
Is something like this possible?
First you need to enter the date parameters for the report via a dialog box
That executes the report
The report is based on a query called qryClientBarrier below:
SELECT tblClient.ID, tblClient.DateOfIntake, tblClientBarriers.*
FROM tblClient INNER JOIN tblClientBarriers ON tblClient.ID =
tblClientBarriers.ClientID
WHERE (((tblClient.DateOfIntake) Between
[Forms]![dlgReportDateRange]![txtStartDate] And
[Forms]![dlgReportDateRange]![txtEndDate]));
The individual barriers for the report use the following DCount expressions
to get the counts:
=DCount("[ClientID]","qryClientBarriers","[bTransportation] =-1")
This is the contol source for each of the different categories of barriers
(unbound textbox)
The client now wants a change to the report to show the barrier with the
highes counts at the top and then descending after it.
So in this case
Low Math skills would be at the top
Transportation would be next followed by Child care and so on and so forth.
Is something like this possible?