You are here:
| Expert | Average Ratings | Expertise | |
|---|---|---|---|
Andy DominguezU.S.
Available
|
I can help setting up tables, create queries, using forms and reports. I can help create update to append queries. I can even help write complex queries. I have knowledge of SQL. I can help import files to create tabs. I have little knowledge of VB. I have used it to refresh screens to running macros when a form closes. | ||
Bob HeiflerU.S.
Available
|
ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING
QUESTIONS Free Microsoft Access Tutorial Videos are available to you at my web site. Fifteen years of Microsoft Access experience allows me to answer most of your questions. Common question example files available here. |
||
Richard RostU.S.
Available
|
|
||
ScottgemU.S.
Available
|
I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design. | ||
Julie MissonAustralia
Available
|
My area of expertise is Microsoft Access 2000-2007. I have been building microsoft databases for the past six years. I would be competent in answering questions from novice Access 2000 users to the more advanced including VBA. If I cannot help, I am more than likely be able to point you to websites that can. |
There are at least 3 ways to do this. I would do it creating a custom function. Another way is with NESTED IIFs a 3rd way is the Switch function. AI Minimum Bid: IIF([AI Value]<50,10,IIF([AI Value]>=50
The first question is why do you have three separate databases? Do the people using the two working databases not have access to a shared drive that the director can also access? Second, If they all
I'm sorry your question is not clear. Are you using Access? Where is the credit card data? What are you trying to extract? Hope this helps, Scott<> Blog: http://scottgem.wordpress.com Website: http://www
I think something went wrong in posting because your table structure is not clear. But if Class and Status have only 2 values each I would not use a lookup table for them. Instead I would make them Yes/No
A query is used to pull information from a table or tables and/or filter information to meet selected criteria. You know your business better than I do so you should be able to come up with the info
Answers by Expert:

©2012 About.com, a part of The New York Times Company. All rights reserved.