Queries not visible

[urs63]

Hi



We have an old mdb (access2000) still used under 2013. No problem at all. If we'd like to use its queries under Word we do not see all of them. I do not understand why... If the version 2000 is saved as an accdb we see the same result - just a few queries are visibile but not all. It does not make a difference if the queries have calculated fields...

Thank you for any help!
REGARDS urs

[ranman256]

Some queries are not avaliable because either
1.it is not a select query
2.the select query requires a parameter

[urs63]

Thank you

just to understand: What is a "select query"? If you're talking about SQL, SQL is not used. Further the german version shows as a property of the chosen query the information: "Typ = Abfrage: Auswahlabfrage" , maybe this is in english "Type = query: Select query"

There are no parameters but calculated fields.

regards Urs

[ranman256]

A select query is SQL that returns records.