Ive been doing databasing for a while. Ive created the basic database, added all the relationships that work (so far), I just have a few issues.
1) I want to create an IF statement, so for example (Im doing a database on a bus company) a driver needs a specific licence to drive certain busses.
How can I do it, so if I choose a driver with a normal licence, it will only show me the busses that require a standard licence?
2) In a query, I want to search for multiple items within the same column. In this case I need to search for items 1, 6, 11, 16, 21 out of a list of 25. Ive tried "=1;6;11;16;21" and 1;6, etc...., but I think Im just being thick and cant grasp it. [Sorted....kind of]
Any and all helps appreciated
1) I want to create an IF statement, so for example (Im doing a database on a bus company) a driver needs a specific licence to drive certain busses.
How can I do it, so if I choose a driver with a normal licence, it will only show me the busses that require a standard licence?
2) In a query, I want to search for multiple items within the same column. In this case I need to search for items 1, 6, 11, 16, 21 out of a list of 25. Ive tried "=1;6;11;16;21" and 1;6, etc...., but I think Im just being thick and cant grasp it. [Sorted....kind of]
Any and all helps appreciated
Last edited: