wedd
12-15-2011, 04:56 AM
Hi access experts! I have this issue in a query on my access database. When I run any queries via QBE I receieve the following error message listed below... Is it possible to resolve this, if so how or what can I do to resolve this issue?
SELECT DISTINCT [Venue] AS Expr2, qrySearchCriteriaSub.[Location], qrySearchCriteriaSub.[Title], qrySearchCriteriaSub.[AreaCode], qrySearchCriteriaSub.[Venue], qrySearchCriteriaSub.[Description] AS Expr3, qrySearchCriteriaSub.[DateofBooking] AS Expr4,' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
Thanks for all your contributions!:friends:
SELECT DISTINCT [Venue] AS Expr2, qrySearchCriteriaSub.[Location], qrySearchCriteriaSub.[Title], qrySearchCriteriaSub.[AreaCode], qrySearchCriteriaSub.[Venue], qrySearchCriteriaSub.[Description] AS Expr3, qrySearchCriteriaSub.[DateofBooking] AS Expr4,' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
Thanks for all your contributions!:friends: