As mentioned by Rich B, you can cross the seconds boundary. It depends when you execute.

2009-11-16 10:48:29.997Monday

2009-11-16 10:48:29.997Monday

2009-11-16 15:48:30.000Monday

2009-11-16 15:48:30.000Monday

I've never done this with views, but stored procedures wortk like a charm.

The trick is in the Access ado form property called Input Parameter.

You place and equalization between your stored...

Thanks Michael! That answers alot. I was just suprised to see this conversion action taking place during a where clause, but it at least it makes some sense...

How about a coalesce statement? This would provide the first non-null entry amountst the 4 date values

Select COALESCE(date1,date2,date3,date4) as Stage

from ......

where....

You could also rever the pattern to check date4...

I would start the process with the Access upsize wizard utility. Since they want to end up with an Access viewer, the upsize wizard wizard will give you two...

If I'm not mistaken, you can highlight all the colums you want to change with a ctrl-click or shift-click. Then make the data type change on the right side...

What error message is being thrown?

Looks like you're being handed a report or screen copy. You can try to run 7 different imports to stagin tables, 1 for each report header line, then one...

I don't have a solution, but shouldn't it be "toys 'r us" with a single quote before the r? Maybe the data can be corrected before you receive it?

Have you tried to change the error handling section for the data source object? You can set the Truncation portion to ignore failure.

Right click on your data source and...

I'm guessing that the pdf is throwing out the initial page break while excel is keeping it. Try changing the Page break at start to a page break at...

I tried to find a "Middle Join" definition thinking they added something new to 2005 which might be helpful.

Can you convert the item to text in the select statement?

SELECT CAST([Item #] as varchar(20)) , [Description], [Pack Size], [Price] FROM

[Database=C:\Test.xls;Excel 8.0;HDR=Yes;IMEX=2].[Sheet1$] Where

[Item #] Is Not Null

It looks like you are summing the sqm total over each widget type, not over the entire dataset.

(See underlined)

Widget factory 1

Widget type 1 50 - 1000 sqm

Widget type 2 75...

I agree. A master adp is the way to go. I created a version table visible through a Help...About menu and placed some version checking in the software....