Thank you for your response:

I've built the (part of) query like this:

(IM.ItemCode BETWEEN '999999' AND 'CL00000'

OR IM.ItemCode NOT LIKE '001920'

OR IM.ItemCode NOT LIKE '001921'

OR IM.ItemCode NOT...

Thanx GrassHopper. Really appreciate it.

Hi there

My column is currently set up as varchar but will change it to the required field if need be.

Kind regards

Fred:-)

Yes, am am using my laptop and access it using (local) [SQL Server (MSSQLSERVER)

That I am not sure of - which server I should be connected to. Can someone please send me in the right direction?

Hi Sir

No, I don't get any errors; it install all the other databases but the OLTP one

Kind regards

Fred

Hi people, this is how I resolved this:

1) Here's my query that I entered into my dataset:

IF OBJECT_ID('tempdb..#testdata') IS NOT NULL

BEGIN

DROP TABLE #testdata

END

SELECT orbpd.BettingPoolNumber

,o.Acronym +...

Thanks for everyone's input. I have sorted this one out.

Kind regards

Hi Sean

Your sql example is right that you have coded above. That is what I have now, one table displaying its contents vertically (as per normal display). In...

Hi guys

Thank you all for your kind responses. I have attached data with an Excel file for anyone to upload. The file consists of the data that I...

It's rather a simple question: I have a table with 25 rows being displayed vertically and I want to display it next to each other in rows of fours.

Kind...

Hi guys and girls

I presently have a table for which the data is displayed as the following:

G P A

1:04 |15 34 |5.1

01:04 |150 9 |13.5

01:04 |25 14 |3.5

01:04 |250 7...