Recent content by elliem19

Hello again! The most annoying thing about my question is how to word it (and therefore how to search existing threads for similar problems). I'm building a query and in a nutshell I have two columns and want to add a third which will multiply the other two together. Simple! BUT... the value...

Well... the good news is... it's fixed! I'm just not quite sure why. The SQL is still the same; Like "*" & forms![General Query]!Notes & "*")); I tried fiddling with the [] brackets, changing the name of the fields and columns, no luck there. What made all the difference, as far as I can...

Thanks for the quick reply Brian... I gave that a go, but still no luck. It currently looks like this WHERE... ... And ((Contacts.Notes) Like "*" & forms![General Query]!Notes & "*")); Am I perhaps mucking up the part that calls for the string? Maybe I've got my syntax wrong with...

Hi again, Hopefully a quick one, I have an unbound form that is used to specify certain criteria for a query. There are up to twelve different fields that a user can enter criteria into, or they can leave some of them blank if need be and the query will ignore them. This is perfect when I'm...

Nope, it would appear I am crashing and burning with this other method. I'm vaguely familiar with loops, but Arrays are out of my league. Are these bits of code VBA or SQL? My initial thought was VBA but now I'm not so sure.

Aha! Such speedy responses and so deliciously simple! Thanks very much to you both, Thank you thank you thank you!! So far I've had success with Brian's easier SQL approach (still relatively new to Access, so baby steps for me) - this is what I ended up with in case other users weren't sure...

Hi all, I have a database of 600+ records containing 12 columns of data per client, things like Name, Contact Number, Email, Postal Code, How they heard of us, Buyer profile etc. I want users of the database to be able to 'build their own query' using an unbound form (with the 12 data fields)...