Search results

Hi all, I need assistance in putting 'UNION ALL' into the following SQL statement: SELECT [zTBL_STATE_GROUP_TABLE 3].STATE, [zqry_nsw/act inconjunctiontable 3].[Total (in conjunction)], [zqry_inconjunction_QLD TABLE 3].[Total (in conjunction)], [zqry_inconjunction_SA/NT TABLE 3].[Total (in...

Hi All, I'm having difficulty counting the number of "Y" and "N" for each suburb. Details: The Table - -------------------------------------------------------- ID- Shop Type-Shop Name-Address1 - Address2 - Suburb - State -------------------------------------------------------- 1 - LP-...

Hi all, I have two sets of columns in MS Access 2003. Column 1: contains suburb + state code, e.g. Altona VIC Column 2: Cotains suburb name, e.g. Altona Would like to find a match for each suburb name, but the state code in column 1 is a problem. I've tried using "Not Like" and the...

Hi, I'm currently designing a database and considering using the following application as a template: http://allenbrowne.com/ser-62.html But I want it to show a "Search Complete" message box after the search is finished. Any tips would be very much appreciated. Thanks You...