Simple Query Help

[P B via AccessMonster.com]

I have a large list of names in a database table which includes things like
account # and Date of Birth, Address, etc.

I want to run a query looking for possible duplicates. I don't have the
duplicate query 'query selection' and so I'm needing to do it from scratch.

I want to match first letter of the last name with the date of birth and
produce a list.

Please advise. Thanks.

 

[Chaim]

What do you mean "I don't have the duplicate query 'query selection'"?

Did you select 'Query' from the 'New Objects' icon on the tool bar? The
'find duplicates query wizard' is one of the selections.

 

[P B via AccessMonster.com]

Exactly. The only two options presents are Create in Design view and Create
using Wizard.

What do you mean "I don't have the duplicate query 'query selection'"?

Did you select 'Query' from the 'New Objects' icon on the tool bar? The
'find duplicates query wizard' is one of the selections.

I have a large list of names in a database table which includes things like

account # and Date of Birth, Address, etc.

[quoted text clipped - 6 lines]

Please advise. Thanks.

 

[Rich S.]

Open up design view and you are going to select the type of query you want
ferom the top bar. The default query is a selct query but if are in design
view, there is a query option in the tool bar. Hit that and you have the
full range of queries to select from. Hope it helps.

Exactly. The only two options presents are Create in Design view and Create
using Wizard.

What do you mean "I don't have the duplicate query 'query selection'"?

Did you select 'Query' from the 'New Objects' icon on the tool bar? The
'find duplicates query wizard' is one of the selections.

I have a large list of names in a database table which includes things like

account # and Date of Birth, Address, etc.

[quoted text clipped - 6 lines]

Please advise. Thanks.

 

[Chaim]

On the tool bar at the top of the Access window, you have the New Object
icon. Part of that icon is a small arrowhead. If you hold your mouse button
down while positioned over that arrow, a list of Access Objects appears, one
of which is Query. Select THAT Query and the New Query window appears. That
has the following choices: Design View, Simple Query Wizard, Crosstab Query
Wizard, Find Duplicates Query Wizard and Find Unmatched Query Wizard.

Find the New Object icon by hovering the mouse over each of the icons on the
toolbar. A balloon will pop up identifying the icon.

It sounds like you are looking for it in the Database window. It isn't
there.
--

Chaim

Exactly. The only two options presents are Create in Design view and Create
using Wizard.

What do you mean "I don't have the duplicate query 'query selection'"?

Did you select 'Query' from the 'New Objects' icon on the tool bar? The
'find duplicates query wizard' is one of the selections.

I have a large list of names in a database table which includes things like

account # and Date of Birth, Address, etc.

[quoted text clipped - 6 lines]

Please advise. Thanks.