ACCESS FEED: [MS_AccessPros] Append Query Where Clause question

Jumat, 30 September 2011

[MS_AccessPros] Append Query Where Clause question

Hi,

I'm new to the group and new to Access. I'm having some issues with an
append query. Here is the SQL:

INSERT INTO dbo_Key_Scans

SELECT dbo_TransMast.*

FROM dbo_TransMast

WHERE (((dbo_Key_Scans.ScanDateTime1) is Null));

When I run this query, Access is prompting me with a parameter for
dbo_Key_Scans.ScanDateTime1. My first thought was, "maybe I have
something spelled wrong?" I checked it numerous times. The query runs
fine without the WHERE clause. What am I doing wrong?

Thanks,

Troy Sherven

MCD, Inc.

Madison, WI

[Non-text portions of this message have been removed]