Filtering and using First() inside a query

[orange]

Yes, I think you could use the table reference directly without the alias. I find the alias easier to understand. Some people use aliases on all tables ( to reduce typing effort).

I'm glad you got it working. And glad to help.



There is a free tool called MZTools for vba. It has a lot of things to help with coding.

It can add Procedure headers and error routines and more.
http://www.mztools.com/v3/mztools3.aspx highly recommended.

Excellent sql reference
http://www.w3schools.com/sql/default.asp

[Gilligan]

I'll definitely be checking out all the links that you have provided for me.

I started with this page and some of my brother's DBs he's made for me over the past couple of years. http://www.teacherclick.com/access2003/index.htm

It was good for getting some better understanding.

Before this all I have done is some basic php/mysql... pretty simple on that end as you are feeding and taking from one piece of code vs forms and queries.

[Gilligan]

Disregard... just my system acting funny I guess.