BAY PALLET BAY PART ...

Many thanks.

I was nearly there as I had replaced ' with a space. Just didnt think about replacing it with a double ''.

New code:-

fld2 = Replace(Range("c" & TShtRow.Row).Value, "'", "''")

I've used option 2 and inserted into a predefined table that I truncate first and then insert via select with order by value descending.

Works a treat.

Very clever stuff!

Always nice to...

Absolutely brilliant solution.

Fits my requirement's 100%.

Many thanks.

Looking at this I'm not sure its possible to do what I want.

I tried using the same font in Excel and then trying to stretch the cells depth and the...

I've tried everything you've said. See code below.

<TableRow>

...

OK thanks guys for looking at this post.

I've got it working by trimming the trailing spaces off query used for the available values field.

I also deleted the project from Report...

I've sorted this by not returning the column names in Excel and hiding the cols with AUG & JUL in them and then on the cols with figures in I've...

I want a select statement I can use in a Excel.

Sorted 😀

Many thanks.

You guys are the best.

Many thanks.

Given that the highest Rev will have a date greater than all the others. Would returning Max (Rev), Max (RevDate) and group by Item always give me the Max...

Cool thanks.

The worry I have is that an error may occur and as its sending out a warning message I can't have the transaction rolled back under any circumstance.

I would therefore...

Yes I d.

So from the test data I would want Date=05/01/2010 and Move = 20

I did a crude subquery sql as follows.

...

(select top 1 date from table2 t2 where...

One last thing.

From your data.

INSERT INTO @Table2 VALUES (01,'P1','01/01/2010',100),

...