graphs are lost when sql server is on the back end

[cutthroatjess]

Greetings,

I have recently moved my back end database to sqlserver. However, I still
use access as my front end. Graphs in my reports are lost now when linked to
the "same" tables. I think I've narrowed it down to some date/time parameters
causing the problems. If I remove the parameters the queries that the
reports/graphs are based on will run. Here is an example parameter: "Between
Now() And DateAdd("d",-30,Now())" Can I use this parameter in a date/time
field located on a sqlserver table?

Thanks!

Jesse