Hello all
Im probably being really thick as Ive been staring at the same screen for the past 6 weeks trying to sort this out.
I will probably keep updating this with issues as I go along, but currently I have:
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 help would be great, or if someone has the time, I can brief you on everything and help me start from scratch if thats easier.