Search results

Hi Everyone, I haven't been back here for a while now, but you guys were so helpful to me before I thought I'd try asking for help on another question I have. :D I have an Access database that is split, and each of the 6 users have a copy of the frontend database on their hard drive. The...

Hi Folks.... this might be something that is pretty basic, but I'm confused so I thought I would ask for your help. I have a query called qry_A and it selects 6 installment dates (Instal1, Instal2, Instal3, Instal4, Instal5, Instal6) from an installment table. I want qry_A to call a custom VBA...

Hi Everyone, this might seem like a trivial question, but I have a query called QRY_A which returns about 5000 rows with fields a, b, c, x, y and z. If I want to get just the unique rows from the results, would it be more efficient for me to use: SELECT DISTINCT a, b, c, x, y, z FROM QRY_A...

Hi I'm new to these forums, so please excuse any errors on my part: Basically, I have a query that is the Record Source for a report. The main query makes use of 2 sub-queries. In one of the sub-queries, it calculates the date of the next call to a customer based on the last call date and...