An interesting quandry, but the increase in cost could be due to you effectively blocking the sales chain.  If they reserve the book for you and you leave it there...

To the three of you I wish the best, and hope that the future is prosporous, what you have created is an amazing resource not to mention and often daily...

The monitor on and off is still a common one for me today, also get annoyed with people referring to the actually PC as the hard drive.

Effecitevely you are looking for a Pivot table, good article here:

http://www.sqlservercentral.com/columnists/plarsson/pivottableformicrosoftsqlserver.asp

I love the big 4, US football, basketball, and baseball.

Erm glad you are not setting up my data structures Steve, seems you have a counting issue

the filter of WHERE     (dbo.RDB_Pub_Auth.RDBPubID = 781)  should only pull three records (as it does) hence why I said using the TOP command upto and including the number of filtered records...

See earlier post - tried the isnull - no luck

BUT

using top x does work - apart from the fact that unless you know how many in the first instance it...

hmmm, no nulls - first thing I checked - only the initials field can allow nulls and with the data I have I have checked.  Anyway with the coalesce function it should...

Whilst not a direct answer, just a pointer - I generate the data onthe fly for reports - about 500 students and have no issues with speed, but this is...

I stay away from the designer for these very reasons, never really know what they are doing all my stuff is straight code

If you do not know the table name then it is a simple matter of getting it by index

i.e.

Me.myDataSet.Tables(0), Me.myDataSet.Tables(1)

etc

Depending on the router you are connecting to/from you may also need to use port forwarding to ensure that it connects to the SQL server (this is of course unless...

Big difference, and if it is a server environment you are looking at then HT switched on has been shown to to reduce a processors efficiency under load. With out getting...

You need to initiate your object as a new one - in this case the opencutomers object by the look of it - whatever class that is based upon i.e

public opencustomers as...

Whilst it sounds a little drastic, Best advice is to move to a better DB server model, most hosting companies will provide some form of relational database (MySQL, SQL Server...