You are here:

Using MS Access/Expert Profile

Scottgem

U.S.

Available

Expertise

I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Experience in the area

I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.

Organizations

Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Average Ratings

Recent Reviews from Users

User	Date	K	C	P	Comments
D	02/10/12	10	10	10	Thank you - works great
Jerry	02/08/12	10	10	10	He homed in on the correct answer .....
John	02/07/12	10	10	10	Thanks Scott
Arthur Trossin	02/07/12	10	10	10	Thank you verry mutch, all works fine .....
beat	02/07/12	10	8	10

Recent Answers from Scottgem

2012-02-09 Access 2007 Query multiple conditions:

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

2012-02-08 Access and Linking Databases:

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

2012-02-08 extract the underlying data:

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

2012-02-07 Forms:

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

2012-02-07 Microsoft Access Queries for Travel Agency:

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

Using MS Access

Answers by Expert:

Browse Answers: