Access Query Problem

  Senator BoB 13:14 26 Apr 03
Locked

Holla,

I've been following instruction which i have infront of me telling me how to create a query using Access... When in design view i am told to click off the Show row under each attribute and then run the Query. If i do this an error appears, "Ouery must have at least one destination field." So i concluded that i should not click of the tick in the Show box? Am i right to assume this or have i done something wrong somewhere else?

Thanks

  Taran 13:27 26 Apr 03

It sounds like you switched everything off so Access has nothing to show you when you run the query.

Removing the tick from the "Show" checkbox renders that field invisible to view once the qury has retrieved your requested information.

Run the query again after leaving at least one field ticked, or your query is a pointless exercise since it will be asking for information that will not be selected for display - hence your error message.

Regards

Taran

  Taran 13:29 26 Apr 03

It's often worth removing the tick from the autonumber/primary key field of your table(s) since it normally isn't necessary to display this information through a query.

Aside from that, leave as much or as little selected for view as you like, provided you leave at least one field visible of course.

T

  Roland Butter 13:29 26 Apr 03

The tick determines the column being displayed in the results of a query. So you will need to have a tick in the "show" box of each column that you want information about.

  Senator BoB 13:39 26 Apr 03

Thanks, that's what i thought i don't know why these note i have tell me otherwise...

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…