where query

I am trying to make a tool based using databases. What i need to do is create a connection query based on a user input. I can get it all to work until i try to add variables into the where statement at the end of the SQL string. Here is the beginning of the code that I have...

I have a question about how to get the most frequently occurring group id for each output area. There are 400+ individual output areas in my list (of 3k+ repeated values) and I need to find the most frequently occurring group for each output area. I created a new list of output areas - with...

Hi Guys, I hope someone can help me with this query! I have a badly written database to fix, I have invoice generating queries that contain the code VAT: IIf([VAT Applicable]=True,[Amount]*0.175,0) If i simply change all of the queries to 15% the historical data will be affected, so I need...