viewing old SQLs (1 Viewer)

[Megacitizen]

I'm looking through some of our older DBs and am trying to access the codes behind some of the queries, so that I can view what they say and try to work out, from those examples, the codes I need for my requirements. However, I only seem able to run a New Query option, rather than view the construction of an existing one.

Is there a way of being able to view the codes for old queries ?

 

[Trevor G]

Can you see the queries in the Database window? If so you could try and use the right mouse button and select design view and you have the design of the query to hand or SQL View.

If you can't see them then what about creating a form based on the query and use the form properties to view the Query.