Query Problem

[SJJB]

I have a query that has actually been in place for some time and has never had a problem working in the past. There is a field for Incident date, with the criteria of [>=]
User is prompted to enter date, and the query is supposed to run. Now for some reason, if a user puts the date in, only the date that is put in is printed out. For some reason the [>=] criteria is not working. Any thoughts as to why?
Thanks

 

[gwinn7]

It would be more helpful if you could provide the SQL Statement of your query.

Gary
gwinn7

 

[SJJB]

SELECT NMR.Cust_Name, NMR.WorkOrderNumber, NMR.[Incident Date], NMR.QtyStarted, NMR.QtyDefective, NMR.QtyScrapped, NMR.ReasonDesc, NMR.ProblemDiscrepancy, NMR.ProblemDescription
FROM NMR
WHERE (((NMR.[Incident Date])=[>=]))
ORDER BY NMR.ReasonDesc;

 

[CaptainD]

SELECT NMR.Cust_Name, NMR.WorkOrderNumber, NMR.[Incident Date], NMR.QtyStarted, NMR.QtyDefective, NMR.QtyScrapped, NMR.ReasonDesc, NMR.ProblemDiscrepancy, NMR.ProblemDescription
FROM NMR
WHERE (((NMR.[Incident Date])=[>=]))ORDER BY NMR.ReasonDesc;

Try this:

WHERE (((NMR.[Incident Date])>=[Enter Date]))ORDER BY NMR.ReasonDesc;

The [Enter Date] should prompt the Input box for you to enter a date.