I have a database that I designed for my users. Sql is the Engine and access is on the front end. I was wondering if there was a way to create a login screen, also if there was a way to create a filter that I can tie into some queries and reports. In Access you can put [] in the criteria area, type in the value and then you get that record/results. SQl server does not recognize this. What do I do, what would be the equivelant??

What is the criteria you wanted to use and what is that you mean by put [], are you referring to [] around the columnname or something else? if you can explain on that it would be better to help.

Cheers!

_________________________
- Vijay G
Strive for Perfection