Query Help

[NewAccessDude]

Hello everyone,

I'm trying to run a query that that checks for information against a current
table. Currently I have a table set up with all of the correct choices and I
want to make my query look at that table and pull anything that is not on
that table, plus any blank information. After which I will be exporting the
information pulled into an excel file.

Thanks!

 

[Jeff Boyce]

I'm having a bit of trouble following your referents ... too many "that"s.

Can you provide an example?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[NewAccessDude]

Sorry

Table A - large imported excel file
Table B - 1 column that contains the correct choices for column A in Table A

Query A - pulls select information from Table A column A that matches with
Table B (or there is no information present).

In the example below it should pull both A2 and A3 and display then entire
row of information that it can be exported to another excel file and
corrections made as necessary

A
1 right
2 wrong
3
4 right

 

[Jeff Boyce]

Thanks for the clarifications.

Now, if I could get you to post back the SQL statement that your query
uses...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[NewAccessDude]

Well currently I don't have an SQL statement, every time I try it gives me an
error message, so I know what i want I just don't know how to get there.

 

[Jeff Boyce]

Sorry, been out of town...

Can you open the query in design view in Access?

If you can, you can change the view to SQL, copy the SQL statement, and
paste it into your post.

If you can't, consider createing a new Access .mdb file (empty) and
importing the underlying tables and queries that THIS query relies on. Then
do the above trick for capturing the SQL statement.

Regards

Jeff Boyce
Microsoft Office/Access MVP