Re: Query Help

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" wrote:

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" <NewAccessDude@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9ED144C2-1512-42D3-B19C-7CAE9536F2F6@xxxxxxxxxxxxxxxx
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" wrote:

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" <NewAccessDude@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:4A413814-A2C2-4818-B345-ACCD571BEC6D@xxxxxxxxxxxxxxxx
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!









.

Relevant Pages

  • Re: Combo box woes
    ... Could you describe again where you are using this SQL statement? ... > query I'm looking up against that I've created looks exactly as below; ... >> Jeff Boyce ... >>> not entirely sure what that is) is set to database default in my ...
    (microsoft.public.access.forms)
  • Re: 2 table Query Error
    ... Post the SQL statement of the query that is giving you this error. ... It is a Country club member accounting database. ... > member ID to member ID) I get the afore memtioned error message. ...
    (microsoft.public.access.queries)
  • Re: Inline CrossTab Query
    ... The SQL I used I just copied from the three queries in the Query Design ... >> I am trying to produce a SQL statement to bring together 3 queries ... >> I am getting an error message that says there is an Error in the ...
    (microsoft.public.access.queries)
  • Re: Report Sum If <=
    ... I saw nothing in the query's SQL statement that mentioned <=24. ... Perhaps you need to do more than one query, ... sum of the hours for attendance codes and then test for the sum for each ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.reports)
  • Re: Eliminating Duplicate Items in a Query
    ... Create a query that returns all the names. ... >> Jeff Boyce ... >> <Access MVP> ... >>>> Without a look at the underlying SQL statement, ...
    (microsoft.public.access.queries)