creating queries

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

Guest

I am a new user a access. When i try to create a query and run it, my result always comes up with no records in it at all.
 
Suzanne,

It could be that your Criteria are, in fact, excluding all records. If
you will post the SQL code for your query, perhaps we can find the answer
there. To view the SQL code for your query, open your query in design
view. From the query's menu, select View|SQL View. Copy all of the text
from the SQL window and paste it into a response to this post.

--

Cheryl Fischer, MVP Microsoft Access



Suzanne said:
I am a new user a access. When i try to create a query and run it, my
Click to expand...
result always comes up with no records in it at all.
 
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 #Error & Excel Pivot 0
Mailmerge specific query results into Word 0
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Access Print Files from Query Results 0
Access stripping decimal places in query 1
Access Query problem 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Calculations, Queries and making it all come together in my table 4

Back
Top