Append Query

  • Thread starter Thread starter Red via AccessMonster.com
  • Start date Start date
R

Red via AccessMonster.com

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
 
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
..
 
Thanks John,

That is exactly what had happened, my confirm was turned off. Thanks for the
help.

VR,

Red
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
Click to expand...
 
Back
Top