Problem on connecting sql database of microsoft access to CReport

[scwk]

hi

help me!

I've done many sql queries on microsoft acess, thus i want to connect this on crystal as database, some sql queries do attach, but some nothing happened, these queries can be said to be complicated, ....i want to know why? and is there any solution? and do crystal report reconized all the syntax of microsoft access? for exemple the NZ function?

It would be very great if someone can help me, and giving me some ideas what can be done
many thanks
sharon

 

[synapsevampire]

Crystal will use queries that it understands to return data, if you have a query that won't show, try creating a simple select * query against that query.

-k