I need to be able to enter into a parameter value part of the value but i do not know the expression to use.
For example when searching an address - 13 Dummy Road
I want to be able to just search the number or just the road name and for my query to show all partial matches.
Is this possible?
The SQL for my current query I want to edit is:
SELECT [Property Details].[Property Ref], [Property Details].[Property Address], [Property Details].County, [Property Details].[Post Code], [Property Details].[Property Type], [Property Details].Bedrooms, [Property Details].Floor, [Property Details].[Start Date], [Property Details].[End Date], [Property Details].Rent, [Property Details].[Guaranteed Rent], [Property Details].Supplier, [Property Details].[Landlord Ref], [Property Details].[Tenant Ref]
FROM [Property Details]
WHERE ((([Property Details].[Property Ref])=[Enter Property Ref:])) OR ((([Property Details].[Property Address])=[Enter Address:])) OR ((([Property Details].[Post Code])=[Enter Postcode:])) OR ((([Property Details].Bedrooms)=[Enter No of Bedrooms:]));