quote:

---

Originally posted by CoachBarker

I have a query that when I run it in SQL Server Management it returns the correct dataset:

SELECT detail_record.detail_number, detail_record.ticket_number, detail_record.division, CAST(detail_record.pickup_dt AS datetime) AS PickupDate,
CAST(detail_record.deliver_dt AS datetime) AS DeliverDate, detail_record.customer_delv_to, detail_record.customer_bill_to,
cmBillTo.customer_number AS bill_to_number, cmBillTo.customer_name AS bill_to_name, cmBillTo.city AS bill_to_city,
cmDelvTo.customer_number AS deliver_to_number, cmDelvTo.customer_name AS deliver_to_name, cmDelvTo.city AS deliver_to_city,
detail_record.pickup_date, detail_record.grand_total_wt, hauler_master.hauler_number, hauler_master.hauler_name, hauler_master.city,
detail_record.ddp_weight, customer_master.customer_number
FROM detail_record INNER JOIN
customer_master AS cmBillTo ON detail_record.customer_bill_to = cmBillTo.customer_number INNER JOIN
customer_master AS cmDelvTo ON detail_record.customer_delv_to = cmDelvTo.customer_number INNER JOIN
hauler_master ON detail_record.hauler_number = hauler_master.hauler_number INNER JOIN
customer_master ON cmBillTo.customer_number = customer_master.customer_number AND
cmDelvTo.customer_number = customer_master.customer_number
WHERE (pickup_date BETWEEN @start_date AND @end_date) AND (customer_bill_to=@customer_number OR customer_delv_to=@customer_number)

ORDER BY detail_record.ticket_number


But when I run it in my report it doesn't.

I am trying to get the data between the @start_date (09/01/2008) and the @end_date(09/30/2008). In SQLServer when I run the query I get the right dataset, everything between 09/01/2008 and 09/30/2008. But in my report the query returns 09, 10, 11.

Can you elaborate this? What do you mean by that?

What am I doing wrong?

Thanks for the help
CoachBarker

---