Query not showing records

[Bmoore]

are you using Text as date field type. becoz' on your posted image it is left align on the datasheet.

In post #7 it shows its Date/Time data type

 

[theDBguy]

I copied and pasted it.... This is what its doing


View attachment 75852

Sorry, I didn't read it close enough. We'll need to take out the Min() part too. So,

WHERE DataT.[Date] BETWEEN [Start Date] And [End Date]

Hope that helps...

 

[arnelgp]

have you already check the Parameter datatype. on the snapshot sql query, I did not see it.

 

[Bmoore]

Thanks alot.... Its working somewhat now... I guess I need to go back format the report coming from that query since its asking me for parameters now. Does that sound right?

 

[Bmoore]

have you already check the Parameter datatype. on the snapshot sql query, I did not see it.

No..... will that cause the report from that query to ask for the parameters of the fields being totaled??

 

[theDBguy]

Thanks alot.... Its working somewhat now... I guess I need to go back format the report coming from that query since its asking me for parameters now. Does that sound right?

Just make sure the parameters in the query and the controls on the report are spelled the exact same way. Cheers!