I`m making a database for a company as my graduation assignment. It is almost finished, but the Queries are still to be done. The company wants to get data out of the database using several input parameters. What is the simplest thing to do? Should I make queries, or use the filter function in Access? The firm that I am working for is not very much into Access, so I must make it simple for them. After much trying, I like the filtering best. Can this be done easely for people who does not have much experience with access? Formfiltering or something??
Query or a filter function?
- Thread starter bmwccn
- Start date
SQL_Hell
SQL Server DBA
- Local time
- Today, 20:31
- Joined
- Dec 4, 2003
- Messages
- 1,359
bmwccn said:
Well, personally I would use Parameterised queries, do something like give them a combo box to select their criteria from, then give them an option to add more different types of criteria into the combo box.
This would be easy and much more maintainable.
If you need advice on how to do this then let me know
SQL_Hell
SQL Server DBA
- Local time
- Today, 20:31
- Joined
- Dec 4, 2003
- Messages
- 1,359
dsmaj said:
No code, sorry mate all in my head.
Ok for an example, if you want to base the criteria of a query from the value of the combo box on a from you could do this:
say the form is called form1 and the combo is called combo1 (original I know)
SELECT *
FROM table
where field1 = forms!form1!combo1
there ya go, hope thats what you meant
