parameters

[cvaccess]

Is there a way to include the date parameters in the query output?

Here is my query:

SELECT DISTINCTROW INDIV_TP_SUB.CHILD_TP AS TP, INDIV_TP_SUB.SCRUB_DATE AS [Scrub Date], rejected_scrubReport.REJ_CODE AS [Reject Code], Count(rejected_scrubReport.MEMBER_NO) AS [Reject Count]
FROM rejected_scrubReport INNER JOIN INDIV_TP_SUB ON (rejected_scrubReport.SCRUB_DATE = INDIV_TP_SUB.SCRUB_DATE) AND (rejected_scrubReport.TP = INDIV_TP_SUB.CHILD_TP)
WHERE (((rejected_scrubReport.SCRUB_DATE) Between [Enter Starting Create Date:] And [Enter Ending Create Date:]) AND ((rejected_scrubReport.TP)=[INDIV_TP_SUB].[CHILD_TP]) AND ((rejected_scrubReport.REJ_CODE)=[Reject Code:]))
GROUP BY INDIV_TP_SUB.CHILD_TP, INDIV_TP_SUB.SCRUB_DATE, rejected_scrubReport.REJ_CODE
ORDER BY INDIV_TP_SUB.CHILD_TP;

I would like to show the Enter Start Date and Enter End Date as a span in the query results.

How could I do this?

Thx

 

[Tranman]

In the select part of the statement, include [Enter Starting Create Date:] as SCD, [Enter Ending Create Date:] as ECD

The values you entered will then be included in the query results as columns SCD and ECD.

Good luck,
Paul

 

[BlackKnight]

Hi,

I am not sure that will work since it may prompt you for the dates twice?

Have a good one!
BK

 

[Tranman]

Nope, only asks once, then it knows what the values are and puts them in the results.

I already have a query like this that prompts for county, highway prefix, highway number, milepost; etc, finds the matches, formats and concatenates the values into a LRS (location referencing system) key.

Try it out.

Paul

 

[cvaccess]

Thanks this worked.