Reply to thread

Message: <blockquote data-quote="Shard O'Glase" data-source="post: 827563" data-attributes="member: 1134">actually excell can run queries.  You could copy your access querry and load it inot excell somehow.  Then you just set up the parameters for how it refreshes.  Like once you type in the site number or something.  I'm much more familiar with access for queries, but I got a few of these excell queries on my computer, I'll see if I can figure out how they are done.I just know that for example my slaes history excell queery, I type in cust number then the date range, once the end datee range is in the queery runs and it instnatly slips into the excell sheet set up.  It meges 3 tables and is really easy to use.  Heck I think they even have a query wizard for those who don't know sql at all.</blockquote>