query1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

sometimes when i run a query based on a query, i'll get an error that says it
is looking for 'query1'.fieldname1 where fieldname1 is whatever fieldname i
happen to be using in my query and 'query1' is query1. the only problem is
there is no query in the database with the name query1, nor is 'query1'
referenced anywhere in the sql statement for the query i am running.

has anyone seen anything like this? anyone have any idea what is going on?

thanks,
lou
 
Post the SQL of your query. Is it possible you have a lookup field in the
underlying table?
 
Eh, I may have found it. I was performing an Int() in one of my fields, and
that kept the source fieldname but removed the source query name. I put the
full path back in(query_name.field_name) and that worked.

Thanks,
Lou
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
how to pass a parameter to a query base of a query that is the base of a report 0
Qry replaces , with > when saved 2
Sumproductlike in Access 1
Variables in Query 1
Check box count from subdatasheet 2
JOIN issue: Valid Syntax to refer to (In FROM clause) the Selected Fields from Query 15
Run 4 queries sequentially with one "click" 8

Back
Top