Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Select specific Records in access
Name: mefaho Date: April 21, 2005 at 04:59:24 Pacific OS: Windows XP CPU/Ram: i don't know
Comment:
I want to select specific records in an Access database consisted of up to 100,000 rows. The specific column, that I want to pick up the records from, starts from A00 to U99. Each record can be from 3 to 10 characters. Your quick is help is appreciated. Thanks Mefaho
Name: smithdk Date: April 21, 2005 at 15:17:43 Pacific
Reply:
A query will serve this purpose. The wizard will help you create one. You can use it to restrict the records to show only what you want it to.
0
Response Number 2
Name: mefaho Date: April 22, 2005 at 02:06:17 Pacific
Reply:
I know how to produce queries for the linked tables but I don't know how to restrict records for one table. Thanks
0
Response Number 3
Name: mefaho Date: April 22, 2005 at 02:23:33 Pacific
Reply:
I think I need syntax, is it right? Can any one help me to create it? Where and how?
0
Response Number 4
Name: smithdk Date: April 22, 2005 at 15:07:09 Pacific
Reply:
Queries are not just for showing more than one table. They can restrict data. If you goto the design view of the query, there is a section there for criteria. That section is used to restrict the data. I'm not exactly sure what restrictions you want.
0
Response Number 5
Name: smithdk Date: April 22, 2005 at 15:12:35 Pacific
Summary: Hi I couldn’t get my answer and I thought I should post it another time: I want to select specific records in an Access database consisted of up to 100,000 rows. The specific column, that I want to ...
Summary: Can anyone please tell me how to remove duplicate records from Access 2000. I have a database with over 400,000 records and I have a lot of duplicates. Whats the easiest way to do this. Thanks for a...
Summary: There is no record limit in Access 2000, but there is a file size limitation which is <= 2GB. Life is more painless for those who are brainless....
0 
