Recent content by Vispon

Thanks for the reply VBA, that's got me somewhere but now I'm encountering a new error message:

In honesty I only actually changed the concatinate action. The original SQL (that works in pgAdmin) is as follows. select rh_pk, rh_company, rh_addr1, rh_pcode, ploc.loc_pcode, cnt_name, cnt_status, cnt_expires, cnt_addr, concatenate(locs.loc_pcode || ' : ' || locs.loc_vehicles || ', ' ||...

Hi Guys, I've recently returned to access (having not used it for a few years) and am stuck on how to fix this syntax error. My SQL ability's quite limited so a friend sent me over the query I needed but it was written for postgres not access. I've made a couple of updates but whenever I run it...

Thanks for the responce I do have access to the query however the users searching a range of things simultaneously, so it could be a combination of 12 different fields which results in no matching records.

Hi Guys I'm not really sure wether this should be in queries or forms (as not sure where the code needs to go) but heres the problem. i have a front end form (where the user has various drop down boxes to choose from) which then runs a query and outputs the results in another form. At the...