Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
question
Starting Member
6 Posts |
 Posted - 2003-09-08 : 08:36:28
|
| Hello all,how do you delete douplicate queries or tables in access?thanks |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-09-08 : 08:44:46
|
| hmmmmmm...- Jeff |
 |
|
|
question
Starting Member
6 Posts |
Posted - 2003-09-08 : 08:51:02
|
| i mean deleting douplicate queries all at the same time not one each time. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-09-08 : 09:03:58
|
| can you give an example of what you mean? How are you defining "Duplicate Queries" ?- Jeff |
|
|
|
question
Starting Member
6 Posts |
Posted - 2003-09-08 : 09:38:57
|
| lets say that you open the queries access menu and you seethe following querries listed:jeffjeff1jeff2jeff3all of them are identical and you like to keep just one, jeffand delete the rest but all at the same time not oneeach time(i know that) |
|
|
|
question
Starting Member
6 Posts |
Posted - 2003-09-08 : 10:29:35
|
| jeff is the example clear? |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-09-08 : 10:41:42
|
| that doesn't mean they are all the same. They have similiar names but how do you know they are exactly the same? Why can't you just delete them 1 by 1? Why do you need to/want to do this?- Jeff |
|
|
|
question
Starting Member
6 Posts |
Posted - 2003-09-08 : 10:48:41
|
| the question is how to delete douplicate queries with one clicknothing less or more. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-09-08 : 10:51:26
|
| Cannot be done; you must do it one at a time. There is not "SHIFT" or "CONTROL" option while selecting queries or tables to select more than 1 in Access.- Jeff |
|
|
|
question
Starting Member
6 Posts |
Posted - 2003-09-08 : 11:33:15
|
| this is what i thought and i raised the questionthanks for the cooaperation |
|
|
|
|
|
|
douplicates