Search results

Here is the sql from my main query PARAMETERS [Start Date? mm/dd/yyyy] DateTime, [End Date? mm/dd/yyyy] DateTime; SELECT LD_SRC.LD_DESC AS Lead, [Start Date? mm/dd/yyyy] AS Start_Date, [End Date? mm/dd/yyyy] AS End_Date, RESULTS.R_DESC AS Results, Count("A"="A") AS rec_cnt...

The field is date/time and I can't copy the db. Sorry.

I figured out the duplicate issue of the end date. (I had two spaces between end and date). Now the report give me an error "Wrong data type for parameter 'End Date? mm/dd/yyyy'. I have the parameter set to date/time. Matt

I have added the [Start Date? mm/dd/yyyy] and the [Start Date? mm/dd/yyyy] parameters to the rtp LEAD TYPE SUCCESS RATE2 query. When I run the query it is prompting me to enter the Start Date once and the End Date twice. Why? When I run the report it prompts me 4 time for start date and 8...

When I run this query TRANSFORM Sum([rpt LEAD TYPE SUCCESS RATE2].rec_cnt) AS SumOfrec_cnt SELECT [rpt LEAD TYPE SUCCESS RATE2].Internal_Rep, [rpt LEAD TYPE SUCCESS RATE2].Lead, [rpt LEAD TYPE SUCCESS RATE2].Start_Date, [rpt LEAD TYPE SUCCESS RATE2].End_Date FROM [rpt LEAD TYPE SUCCESS...

Hello All, I am new to this forum and need help. I have been out of Access for server years/version and I am trying to get up to speed. Matt