Welcome to the Australian Ford Forums forum.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and inserts advertising. By joining our free community you will have access to post topics, communicate privately with other members, respond to polls, upload content and access many other special features without post based advertising banners. Registration is simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Please Note: All new registrations go through a manual approval queue to keep spammers out. This is checked twice each day so there will be a delay before your registration is activated.

Go Back   Australian Ford Forums > General Topics > Non Ford Related Community Forums > The Bar

The Bar For non Automotive Related Chat

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 08-04-2005, 11:27 AM   #1
b2tf
not here much anymore
 
b2tf's Avatar
 
Join Date: Dec 2004
Location: Sthn NSW
Posts: 22,918
Default Microsoft Access Formulas

Hoping someone here is better at these than i am. Im currently trying to setup a database to help us find out where our business is coming from (i.e. what advertising is working best). So, i have columns set up for each place where we advertise.
I need to enter a rule that makes sure only one can be ticked for each client (i.e. you cant say that they found us from both Phone Book and TV), but i cant work out what that rule is.

The example in the Help section is that >9 = Must be 10 or more.

Basically, i need to enter it so that once on box is ticked, you cannot tick another. Anyone got any idea what the formula for that is?!

Kinda need this ASAP.
__________________
2024 F150 XLT
b2tf is offline   Reply With Quote Multi-Quote with this Post
 


Forum Jump


All times are GMT +11. The time now is 05:39 AM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Other than what is legally copyrighted by the respective owners, this site is copyright www.fordforums.com.au
Positive SSL