I am trying to teach Statistics using SQL and RDB tables.
http://www.amazon.com/Microsoft-Access-Data-Analysis-Unleashing/dp/076459978X/
I am looking for a books or resources like above either for ACCESS (<= 2003)
or SQL Server Express.

I have a table: with the following columns
ID(AutoNumber)     Serial Number(11 digit number)
In the Seriial number field there are a lot of values that are
duplicates What I would like is that every time I find a duplicate

With this expression my results are not coming out right. I am converting
seconds into hours.  If i do not put in the -8 hours it is correct. Should I
use the calculation with the minus 8 hours in seconds first.  What options do
I have?

When I try to make a label in Access 2007 at the end a window pops up asking
for a parameter value and there is a word that says "trim"  What do I put
there?  I upgraded the database from an earlier version of Access and this
never was an issue.  Even if I try to open previous ...

I'm trying to select a group of records that has blank date field but I can't
seem to figure out the proper criteria to use in my query. I appreciate your
help.

I am using Union to bring two tables together.  Before the union, one
query has 1500 results and the other 97.  After the union I have only
1350 results.  I should have 1597.  What could be the reasons behind
receiving fewer records after a union than what each of the union

I was hoping you would have some time to help me with a problem. Randomly one
of my forms stoped allowing entery and when i looked into in the table had
been populatied with data from the wrong text boxes. I checked the form and
they were still connected properally nothing had ...

MS Access 2003
QuickBooks Enterprise Solutions 7.0
Connection String:
ODBC;DSN=QuickBooks Data;SERVER=QODBC;OptimizerDBFolder=C:\Documents and

I hope this is the appropriate group for a question like this, which
involves Queries, Recordset, and VB. Okay, its looking as though I
might be over my head with some code here. Any help would be
appreciated.

I'm working on a procedure to 'package' a query to export it to a file,
email it and allow the peson on the other end to import it.
I want to be able to package the query description as well - and to write it
on the other end - but for the life of me, I don't see how I can ...

I know that this is not actually a query.
I have a form that has a value set in Me.ServiceID.
In a table Services (which is NOT the data source for the form) there is a
pair of values, ServiceID and ServiceName.

I have imported in MS Access 2003 a SQL Server table that has binary id
columns.  When I look at the design view for the table, the column type is
binary -- which is strange since I thought binary was not a valid column
type.  The column contains the binary represntation of a ...

Thanks for any help.
I have a make table query, and I would like it each time to make it in the
Courier font, so that digits line up. But it makes it in some other font, and
I have to select all and change it each time I re run the query. Which seems

Is there a way to put criterias statment in the table then have query look it
up in the table?
for example:  in a table under "criteria" column, i put :  not like camp*
and not like motor*

I am trying to set up a query that will find things like ID code V48.3.  
However, I find that I can not enter the period of the 48.3 in the perameter
text.  Is there a way around this?
Thanks in advance and have a nice day.