G
Guest
I want to display a query and have it be read only, no updates or adds.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
Try changing it to a Distinct query, either by going into the query's
Properties when you've got it in Design View and setting the UniqueValues
property to True, or by going into its SQL View and change SELECT to SELECT
DISTINCT.
Properties when you've got it in Design View and setting the UniqueValues
property to True, or by going into its SQL View and change SELECT to SELECT
DISTINCT.
T
tina
suggest you bind the query to a form, and set the form's RecordsetType to
Snapshot.
hth
Snapshot.
hth
G
Guest
This works just fine since I'm using the query in a form.
G
Guest
This does work if UniqueValues is set to yes
Douglas J. Steele said:Try changing it to a Distinct query, either by going into the query's
Properties when you've got it in Design View and setting the UniqueValues
property to True, or by going into its SQL View and change SELECT to SELECT
DISTINCT.