Search results

Re: Help with inserting a 'UNION ALL' *SQL query* [RESOLVED] I've got it working! What I did was delete a table that had 'RIGHT JOIN' to it and did a 'UNION ALL' on each table, but this resulted in deleting the STATES column (which wasn't needed anyways). I've attached the result I got. The...

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 jal, I also tried your solution and it works. Your example database "Suburbs.mdb" illustrated the solution very well. Thank You so much, Dave.

Hi Galaxiom, Thank You so much, it worked very well, I go the results needed. Thank You, Dave.

Sorry, I left out one column, it should be: ---------------------------------------------------------------------- ID- Shop Type-Shop Name-Address1 - Address2 - Suburb - State-Yes/No ---------------------------------------------------------------------- Thank You, Dave

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 jjturner, Thank You X 1000 Cheers, Dave

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 SOS, Thank You so much for your help, it worked really well!

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...

Can you give me some more information on the two or four tables that you've created?

Sorry I meant the macro one.

That's great!!!! I also learnt a few useful things from George145 as well.

Please post your code.

Looks like an assignment. I won't tell exactly what the answer is, but I'll guide you there. Anyways, here are some code that may get you going. I haven't tested the codes yet. Also you need to add two more text boxes. Good Luck! Code: 'Date example If Not IsNull(Me.txtStartDate) Then...

Try changing the foreign key names to its Primary keys name. e.g. "c_parentId to "parentId". Also change your code accordingly.

Just for now try doing this: For the TAC column, do a Trim function to get rid of those ":", then create a primary key and a foreign key(primary key ID -1) column, self join the two columns, and do the calculations. Example: [TAC] 9:43 9:50...

Please post a picture of the relationship diagram between the tables. I think there may be a flaw there.

Found a website that may hopefully assist you. Sample code for timer code + refresh form: http://www.blueclaw-db.com/access_event_programming/timer.htm

Hi, We will start with Question A. When you are in the form wizard: - under "Tables/Queries" select Query:XXX (books with baic info table) - Click on the ">>" -Next -Option button "Datasheet" -Finish After these steps go into "Form View", this should show you the form with the tables info...