Thanks JLK, that was helpful!

This article was the most helpful.

http://support.microsoft.com/kb/224071/

Thanks!

I found this information on the subject but I trying to understand it.

http://support.microsoft.com/kb/314546/

Oh, so that is the problem! Sorry. THanks! I changed the names of the tables months ago and haven't looked a the new code since. I correct a lot of...

Thanks guys! This is great help.

I already know SQL. I need to learn T-SQL.

Thanks. I will look at these books and buy them.

I've ordered an Access book. MS Access Inside Out, but I don't know how long it will take Purchasing to get them for me.  Do you have any clue where...

Thanks! This is a small project. I wasn't really planning to use SQL Server on this one. Just Access.

What do you think?

Thanks!

Thanks guys! One problem i solved by putting the info in by hand. the other problem i solved by restarting the computer because of virtual memory problem. After that and...

Ok, as an alternative, i simply created a new DB using the attribute headers for the column names. This worked and i was able to change the datatype as before. ...

Thanks for the information guys.

I should have mentioned, they won't be changing or updating any of the information, they will only be doing data entry.

Thanks very much for the information. I have only one further question. 

"Each person will have to have their own local copy of the ADP, and use their local copy...

Thanks for the information Steve. I'll take a look at it.

thanks!

Thanks I did notice that!  thanks!

Thanks SO VERY MUCH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

It looks like it had to do with the order of the clauses.  I needed to move the order by beneathe the having clause just as...

Thanks guys! I got it to work based on the info you guys gave me.

Do you know where i can find online rules for creating queries that are not necessarily...