If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Append Query
Good day everyone,
I have an append query that is mis-behaving. When I view the query it shows the correct records that should append but when I actually run the query, nothing happens. I dont get the append warning- nothing happens. I have included my sql for your reference. What I can't figure out is why I can see the data when I view the query and the data is there but won't run. Any help will be greatly appreciated. INSERT INTO [Basic Patient Data] ( [Pat SSN], [Last Name], [First Name], Branch, Rank, [Email Work], [Work Phone], [Unit Assigned], [Base Assigned], Deros ) SELECT [Waiting List Data].[Pat SSN], [Waiting List Data].[Last Name], [Waiting List Data].[First Name], [Waiting List Data].Branch, [Waiting List Data].Rank, [Waiting List Data].[Email Work], [Waiting List Data].[Work Phone] , [Waiting List Data].[Unit Assigned], [Waiting List Data].[Base Assigned], [Waiting List Data].Deros FROM [Waiting List Data] LEFT JOIN [Basic Patient Data] ON ([Waiting List Data].[First Name] = [Basic Patient Data].[First Name]) AND ([Waiting List Data].[Last Name] = [Basic Patient Data].[Last Name]) AND ([Waiting List Data] .[Pat SSN] = [Basic Patient Data].[Pat SSN]) WHERE ((([Basic Patient Data].[Pat SSN]) Is Null) AND (([Basic Patient Data]. [Last Name]) Is Null) AND (([Basic Patient Data].[First Name]) Is Null)); VR, Red -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200702/1 |
#2
|
|||
|
|||
Append Query
Is this the only append query that you have that fails?
Have you turned off warnings? That is in Tools:Options:Edit/Find have you unchecked confirm Action queries or have you used a macro or vba to Set Warnings to False. The query looks good. And when you run the query you should be getting a warning message unless you've turned them off. -- John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County .. "Red via AccessMonster.com" u15475@uwe wrote in message news:6e08ff2822d1f@uwe... Good day everyone, I have an append query that is mis-behaving. When I view the query it shows the correct records that should append but when I actually run the query, nothing happens. I dont get the append warning- nothing happens. I have included my sql for your reference. What I can't figure out is why I can see the data when I view the query and the data is there but won't run. Any help will be greatly appreciated. INSERT INTO [Basic Patient Data] ( [Pat SSN], [Last Name], [First Name], Branch, Rank, [Email Work], [Work Phone], [Unit Assigned], [Base Assigned], Deros ) SELECT [Waiting List Data].[Pat SSN], [Waiting List Data].[Last Name], [Waiting List Data].[First Name], [Waiting List Data].Branch, [Waiting List Data].Rank, [Waiting List Data].[Email Work], [Waiting List Data].[Work Phone] , [Waiting List Data].[Unit Assigned], [Waiting List Data].[Base Assigned], [Waiting List Data].Deros FROM [Waiting List Data] LEFT JOIN [Basic Patient Data] ON ([Waiting List Data].[First Name] = [Basic Patient Data].[First Name]) AND ([Waiting List Data].[Last Name] = [Basic Patient Data].[Last Name]) AND ([Waiting List Data] [Pat SSN] = [Basic Patient Data].[Pat SSN]) WHERE ((([Basic Patient Data].[Pat SSN]) Is Null) AND (([Basic Patient Data]. [Last Name]) Is Null) AND (([Basic Patient Data].[First Name]) Is Null)); VR, Red -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200702/1 |
#3
|
|||
|
|||
Append Query
One possibility is that the SetWarnings have been turned off. Can you
confirm that SetWarnings is On? -- Regards Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ "Red via AccessMonster.com" u15475@uwe wrote in message news:6e08ff2822d1f@uwe... Good day everyone, I have an append query that is mis-behaving. When I view the query it shows the correct records that should append but when I actually run the query, nothing happens. I dont get the append warning- nothing happens. I have included my sql for your reference. What I can't figure out is why I can see the data when I view the query and the data is there but won't run. Any help will be greatly appreciated. INSERT INTO [Basic Patient Data] ( [Pat SSN], [Last Name], [First Name], Branch, Rank, [Email Work], [Work Phone], [Unit Assigned], [Base Assigned], Deros ) SELECT [Waiting List Data].[Pat SSN], [Waiting List Data].[Last Name], [Waiting List Data].[First Name], [Waiting List Data].Branch, [Waiting List Data].Rank, [Waiting List Data].[Email Work], [Waiting List Data].[Work Phone] , [Waiting List Data].[Unit Assigned], [Waiting List Data].[Base Assigned], [Waiting List Data].Deros FROM [Waiting List Data] LEFT JOIN [Basic Patient Data] ON ([Waiting List Data].[First Name] = [Basic Patient Data].[First Name]) AND ([Waiting List Data].[Last Name] = [Basic Patient Data].[Last Name]) AND ([Waiting List Data] [Pat SSN] = [Basic Patient Data].[Pat SSN]) WHERE ((([Basic Patient Data].[Pat SSN]) Is Null) AND (([Basic Patient Data]. [Last Name]) Is Null) AND (([Basic Patient Data].[First Name]) Is Null)); VR, Red -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200702/1 |
#4
|
|||
|
|||
Append Query
Thanks John,
That is exactly what had happened, my confirm was turned off. Thanks for the help. VR, Red Red wrote: Good day everyone, I have an append query that is mis-behaving. When I view the query it shows the correct records that should append but when I actually run the query, nothing happens. I dont get the append warning- nothing happens. I have included my sql for your reference. What I can't figure out is why I can see the data when I view the query and the data is there but won't run. Any help will be greatly appreciated. INSERT INTO [Basic Patient Data] ( [Pat SSN], [Last Name], [First Name], Branch, Rank, [Email Work], [Work Phone], [Unit Assigned], [Base Assigned], Deros ) SELECT [Waiting List Data].[Pat SSN], [Waiting List Data].[Last Name], [Waiting List Data].[First Name], [Waiting List Data].Branch, [Waiting List Data].Rank, [Waiting List Data].[Email Work], [Waiting List Data].[Work Phone] , [Waiting List Data].[Unit Assigned], [Waiting List Data].[Base Assigned], [Waiting List Data].Deros FROM [Waiting List Data] LEFT JOIN [Basic Patient Data] ON ([Waiting List Data].[First Name] = [Basic Patient Data].[First Name]) AND ([Waiting List Data].[Last Name] = [Basic Patient Data].[Last Name]) AND ([Waiting List Data] .[Pat SSN] = [Basic Patient Data].[Pat SSN]) WHERE ((([Basic Patient Data].[Pat SSN]) Is Null) AND (([Basic Patient Data]. [Last Name]) Is Null) AND (([Basic Patient Data].[First Name]) Is Null)); VR, Red -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200702/1 |
#5
|
|||
|
|||
Append Query
Thanks Jeff, you were exactly right, I had turned off my confirm action.
Many thanks, Red Jeff Boyce wrote: One possibility is that the SetWarnings have been turned off. Can you confirm that SetWarnings is On? Good day everyone, [quoted text clipped - 23 lines] Red -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200702/1 |
Thread Tools | |
Display Modes | |
|
|