I have a consultant who is going to write a custom report for us using our Education Edge tables.  He wants to write an MS Query to link to the database tables - and I'm not sure how to go about making that connection.  In the past I have used an export to create an MDB file that I then used to create the report in Crystal.  His theory is that we can avoid that step by using MSQuery and linking directly to the database.  I'm assuming this is possible - but need some tips on how to make this happen.

Thanks

Candace Chesler

The Frances Xavier Warde School

Chicago, IL