Thanks for pointing that out. I wouldn't have recognized that as part of the problem. I'm not the OP, but it sure is good to learn...

Here's the solution for a single addressident:

DECLARE @ADDRESSES TABLE (

rownumber int,

addressident int,

vchaddress varchar(15),

datechanged DateTime

PRIMARY KEY(addressident, rownumber)

)

INSERT INTO @ADDRESSES

SELECT 1,1,'1234 park st','1-1-2000' UNION ALL

SELECT 2,1,'1234 park st','1-2-2000' UNION ALL

SELECT 3,1,'1234 park...

Robert,

Here's some simple code to demonstrate the results:

DECLARE @test-2 TABLE (

N int

PRIMARY KEY(N)

)

INSERT INTO @test-2

SELECT 199000 UNION ALL

SELECT 199700 UNION ALL

SELECT 199701 UNION ALL

SELECT 199702 UNION...

Robert,

I stand by my post, as NOT BETWEEN 199701 and 199901 would never allow either of the stated values of 199701 or 199901 to meet the criteria, whereas simply placing...

There are several factors that can cause problems for Crystal Reports, or for any kind of database connection. First and foremost is your internet speed. Use...

Actually, the result of NOT BETWEEN and the previously stated pair of inequalities would be different.

1.) LTE 199701 AND GTE 199901 would produce no records, as it's not possible for...

If you're unable to change the table to allow null values for a given column, it's likely that there's an index that requires unique values for that column. ...

I now have an interesting problem with an Access 2003 adp file, based on my testing of the supposedly trivial conversion. My tables are all in a particular...

Glad you got it working. As to the file attachment, you might want to try specifying a complete path, including the drive letter.

Steve

(aka smunson)

:):):)

The ALTER would fail unless you also specified the code needed to tell it not to check the existing values. However, that wouldn't really solve the problem, as...

It's also missing an END statement to match up with the BEGIN. Some other things to look at include the error log, if any, that would be associated...

Well, as to creating a simple GUI, Access has the ease of development, AND, it has the means to use the same code as VBScript in terms of accessing the...

Gee, that sure was helpful... Remind me why I needed that?

Not everyone can know everything, and I fail to see that any of the apps I've developed over...

Wow... trivial effort, eh? I think not. I migrated my queries, of which it created only those that didn't have parameters as views, and instead of...

Apparently, one can't have local queries in an adp file - at least that you use as a recordsource for a combo box anyway. Thus I'm going to...