And Using a query to select data in one field compared to another

[Guest]

I want to use a query to select data based on a comparison between two
fields. For example: Field one is a phone number, field two is a phone
number.
I want to query to compare field wanted field to infield one equals field to
the 90 the query to pull a selection from separate fields. Such as field
four and six which contained an ID number and a total charge. Can anyone
help?

 

[Rick B]

What does this mean:

I want to query to compare field wanted field to infield one equals field to
the 90 the query to pull a selection from separate fields

You might consider naming your fields something more meaningful than field
one and field two. When posting a question, it is helpful to set off the
field names (maybe in brackets or remove spaces) so your post can be read.

For example:
I want the query to compare [PhoneNumberWanted] to the
[PhoneNumberEntered]...

 

[Guest]

Hi Rusty,

Could you restate the question? Seems like the second paragraph got messed
up with some cutting and pasting or something.

 

[Guest]

Sorry about that.
This is what I'm trying to do. I want to create a query that will compare a
given field with another given field.
For example: [Phone number 1] with [phone number 2] if the two fields are
the same that I want to select data from separate fields such as [ID number]
and [total]. And then send ID number and total to a separate table to be
exported as a text file.

What does this mean:

I want to query to compare field wanted field to infield one equals field to
the 90 the query to pull a selection from separate fields

You might consider naming your fields something more meaningful than field
one and field two. When posting a question, it is helpful to set off the
field names (maybe in brackets or remove spaces) so your post can be read.

For example:
I want the query to compare [PhoneNumberWanted] to the
[PhoneNumberEntered]...


--
Rick B

I want to use a query to select data based on a comparison between two
fields. For example: Field one is a phone number, field two is a phone
number.
I want to query to compare field wanted field to infield one equals field
to
the 90 the query to pull a selection from separate fields. Such as field
four and six which contained an ID number and a total charge. Can anyone
help?

 

[Rick B]

Well, I'd just build a query and in the criteria for [PhoneNumber1] I'd put
something like...

=[PhoneNumber2]

That will only pull records where the two match.

Then, simply include the two fields you want to export in your query. After
you run the query, export it. I would NOT store any of the result to a
table. That is an unneeded step that will just clutter up your database and
lead to problems if the data changes and you forget to update that table
based on the new data.

--
Rick B

Sorry about that.
This is what I'm trying to do. I want to create a query that will compare
a
given field with another given field.
For example: [Phone number 1] with [phone number 2] if the two fields are
the same that I want to select data from separate fields such as [ID
number]
and [total]. And then send ID number and total to a separate table to be
exported as a text file.

What does this mean:

I want to query to compare field wanted field to infield one equals field
to
the 90 the query to pull a selection from separate fields

You might consider naming your fields something more meaningful than
field
one and field two. When posting a question, it is helpful to set off the
field names (maybe in brackets or remove spaces) so your post can be
read.

For example:
I want the query to compare [PhoneNumberWanted] to the
[PhoneNumberEntered]...


--
Rick B

I want to use a query to select data based on a comparison between two
fields. For example: Field one is a phone number, field two is a
phone
number.
I want to query to compare field wanted field to infield one equals
field
to
the 90 the query to pull a selection from separate fields. Such as
field
four and six which contained an ID number and a total charge. Can
anyone
help?