Hi all,
Pretty been working with access for a few years, just for small companies etc I work with. This current employer needs a database of items which are specific to vehicles.
This has been pretty well built and happy with it so far. However I am trying to set up a search query to bring up all versions and years of the requested model. Obvously I have prompt to enter the Model required,
however i need the results to expand to all entries with MOndeo in that field. Some have years, some have MK classifcations. I have been trying all the compinations of prompts and wild cards but to no avail.
In criteria area for the Model field I have =[Enter Model Required], which obviously looks for the model, lets say, MONDEO. However the variations in that field within the data are like:
Mondeo MK4 Mondeo MK4 (Bootmat - 8495) Mondeo MK4 (Bootmat Set - 8495) Mondeo (Bootmat - 8491) Mondeo (Bootmat - 8496) Mondeo (Bootmat - 8497) Mondeo Mondeo Hatchback (Bootmat - 8810) Mondeo Hatchback (Bootmat Set - 8810)
So how can I allow user to add Mondeo, to the query and bring all entries for display.
Now driving me nuts.
Anyone have an idea how to achieve this please?
Thanks in advance.
Mick