-
displaying recordsbased on a particular field
Hi
I was wondering if you could answer a question I have since I am a first tim eSQL MS Access user. I have 4 fields in my table called date, name, type. I want to display all the recods of a certain type by having the user input the type. How can I do this ? Do I have to create a query ?
Thanks for any help
Regards
Nitin
-
Re: displaying recordsbased on a particular field
Originally posted by nlgonsal
Hi
I was wondering if you could answer a question I have since I am a first tim eSQL MS Access user. I have 4 fields in my table called date, name, type. I want to display all the recods of a certain type by having the user input the type. How can I do this ? Do I have to create a query ?
Thanks for any help
Regards
Nitin
Create a query in the design view, add the table and all the fields and in the criteria box below type put
[Enter the type]
in square brackets. The user will be prompted when you run the query.
-
another question on displaying records
Hi
I have just leaned that the requirements for displaying the records has changed. What is needed is some kind of combobox with the different types in it, and then when one of these is clicked on, all the records with that type are displayed.
Sorry about this.
Thanks
Regards
Nitin
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|