Weird Query issue

[RayMilhon]

I have a query based on 2 other Queries.

SELECT Query1.PROVIDER, Query1.MEMBER, Query1.MEMBID, query2.DATEFROM, query1.[PROCEDURES AUTHORIZED], query2.PROCCODE, query2.AUTHNO, query2.CLAIMNO
FROM query2 INNER JOIN query1 ON (query2.MEMB_KEYID = query1.MEMB_KEYID) AND (query2.PROV_KEYID = query1.PROV_KEYID) AND (query2.AUTHNO = query1.AUTHNO);

Query 1 has a date field that is set to pull all records Greater than or equal to 01/01/2016 The parameter is hardcoded in the query. If I run query1 I get no prompt. However, on the query above I get prompted repeatedly to enter the parameter for that field.

Query 1:

SELECT dbo_PROV_VENDINFO.VENDOR, dbo_PROV_COMPANY_V.PROV_KEYID, dbo_PROV_COMPANY_V.REV_FULLNAME AS PROVIDER, dbo_MEMB_COMPANY_V.MEMB_KEYID, dbo_MEMB_COMPANY_V.REV_FULLNAME AS MEMBER, dbo_MEMB_COMPANY_V.MEMBID, dbo_AUTH_MASTERS_V.REQDATE, dbo_AUTH_MASTERS_V.AUTHDATE, dbo_AUTH_MASTERS_V.EXPRDATE, dbo_AUTH_DETAILS_V.PROCCODE AS [PROCEDURES AUTHORIZED], dbo_AUTH_MASTERS_V.AUTHNO, dbo_AUTH_MASTERS_V.STATUS
FROM ((((dbo_AUTH_MASTERS_V INNER JOIN dbo_AUTH_DETAILS_V ON dbo_AUTH_MASTERS_V.AUTHNO = dbo_AUTH_DETAILS_V.AUTHNO) INNER JOIN dbo_MEMB_COMPANY_V ON dbo_AUTH_MASTERS_V.MEMB_KEYID = dbo_MEMB_COMPANY_V.MEMB_KEYID) INNER JOIN tbl_HPCODEs ON dbo_MEMB_COMPANY_V.HPCODE = tbl_HPCODEs.HPCODE) INNER JOIN dbo_PROV_COMPANY_V ON dbo_AUTH_MASTERS_V.REQPROV_KEYID = dbo_PROV_COMPANY_V.PROV_KEYID) INNER JOIN dbo_PROV_VENDINFO ON dbo_PROV_COMPANY_V.PROV_KEYID = dbo_PROV_VENDINFO.PROV_KEYID
WHERE (((dbo_PROV_VENDINFO.VENDOR)="3613") AND ((dbo_AUTH_MASTERS_V.REQDATE)>=#1/1/2016#) AND ((dbo_AUTH_MASTERS_V.STATUS)="1"))
ORDER BY dbo_PROV_COMPANY_V.REV_FULLNAME, dbo_MEMB_COMPANY_V.REV_FULLNAME;

As you can see all of the where conditions are hard-coded. No need for parameters as this is a one time request for a specific vendor. Any idea why I would get prompted for this?

[pbaldy]

Does query2 have similar parameters? Perhaps the prompts come from there.

[RayMilhon]

No The prompt message clearly shows Query1.REQDATE as the field being prompted for. Also query2 does not contain that field at all.

[pbaldy]

That is certainly odd, since it isn't even in the SELECT list of the final query. Can you attach a sample db that does this?

[RayMilhon]

Still not sure what was going on but had to do a reboot of the computer for other reasons and that error went away. Query runs as it should now.

[pbaldy]

Weird. Well, the IT guy's rule-of-thumb: rebooting solves 90% of the problems.