Hi, I'm basically new with Access but i have experience with SQL Server and Macros.

I was able to link Access with SQL Server. I want to use Access the interface of my system and SQL Server handles my databases.

What I want to do is by using macro, the system will check the value of a specific column and display it on a label box. If there are no records, it will simply display "1".



thanks in advance