You are here:
Using MS Access/Expert Profile
Expertise
I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site.
Experience in the area
I am the president of AccessLearningZone.com and 599CD.com. I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.
Education/Credentials
I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com
Average Ratings
Recent Reviews from Users
K = Knowledgeability C = Clarity of Response T = Timeliness P = Politeness| User | Date | K | C | T | P | Comments |
|---|---|---|---|---|---|---|
| Todd | 11/17/09 | 10 | 10 | 10 | 10 | Sorry my question wasn't clear enough. I ..... |
| catherine | 11/13/09 | 10 | 10 | 7 | 10 | |
| Gail | 11/13/09 | 10 | 10 | 7 | 10 | He gave me a simple solution that ..... |
| Adam | 10/21/09 | 10 | 10 | 10 | 10 | Thanks, got this working now. |
| Rich | 10/20/09 | 10 | 10 | 10 | 10 | He was quick to respond and gave ..... |
Recent Answers from Richard Rost
2009-11-17 lookup equation for foreign exchange DB:
You can use the DLOOKUP function to look up a specific value from a table or query. Please see the following FREE video tutorial on my web site for step-by-step instructions on how to use DLOOKUP:
2009-11-17 database reports:
Forms don't hold data. TABLES hold data. If your form was designed properly, it saves its data in a table. Your report should also get its data from a table, not directly from a form (there are exceptions
2009-11-12 Query Combo all values:
Sure, just add an IIF function to your query: =IIF(IsNull(Forms!MyForm!MyComboBox),X,Forms!MyForm!MyComboBox) Set X equal to your field name. This way, it will show all records if the combo box is
2009-11-10 summing data in a ranged query or report:
To do this, use an Aggregate Query... also called a Summary Query or Totals Query. There is a little button on the query toolbar that looks like a wierd "E" (actually the Greek letter Sigma). Press that
2009-11-09 Converting a multiple-value field into several different fields:
I'm not sure I understand your question correctly. If you could show me a sample of data and what you need that would help. But if I understand you correctly, you just need to create a query, joined by
Answers by Expert:
©2009 About.com, a part of The New York Times Company. All rights reserved.