Search results

I have done something similar and it works for me. I think you need to include a wildcard in the query for each form field that could be left blank by the user, looks like you have done this in the same way as I did though, and I am not sure that helps much now I read it back!!! Graham

This is pretty much beyond me, I am not an expert by any stretch of the imagination, but is there a ; missing somewhere? Graham

Tophan, you can insert the SELECT DISTINCT * using the SQL view.

Hi all, I've joined the group after finding some good tips to help me with an access front end reporting from an oracle db. Access experience is limited but getting better using the "google it and play with the result" method along with a couple of good books. Queries are getting "smarter" and...