About > AllExperts  
Search for
  Main Menu Ask a Question Browse Past Answers Meet Top Experts Be an Expert Login (Experts Only)
About Us  ·  FAQ  ·  Tell Friends About Us  ·  Link To Us  ·  Free Encyclopedia  ·  Disclaimer  ·  Tech Support   
  You are here:  AllExperts > Computing/Technology > Oracle > Data Management & Storage

Expert Profile: ScottGem

Expertise:  I have been an IT professional for over 16 years. During that time I have accumulated a large store of knowledge and experience. This allows me to assist with a large variety of technology issues. My specialty is Database design primarily with MS Access. However, I can answer questions on many different IT related topics.

Experience in the area
I have worked in IT support for over 16 years. I have also helped people in cyberspace for a good portion of that time. I have been a volunteer staffer on Prodigy and AOL. I was the #2 ranked expert at AskMe.com (#1 in Technology) and am currently ranked at or near the top at Answerway.com and PointAsk.com.

Ask a Question       View Past Answers       View Ratings            
Average Ratings
Prestige Points: 73414
Knowledge   9.60   Best of the best
Clarity of Response   9.80   Best of the best
Timeliness   9.96   Best of the best
Politeness   9.85   Best of the best
Number Of Questions
(in Past 24 Hours)
0
Max Questions to be Asked
(in 24 Hour period)
5
Total Questions
(since joining AllExperts)
392
Recent Reviews from Users
KnowlClarityTimePolitenessDate
1010101009/29/08
1010101009/02/08
1010101008/10/08
1010101008/10/08
1010101008/08/08
User Comments
Perfect....and fast...thanks a ton!!
(Ironman on 09/29/08)
Thankyou you've been very helpful and deserve all ten's. Continu with the good service you're doing
(tino on 09/02/08)
Immediate and succint answer. Just waht I wanted.
(Peter on 08/10/08)
ScottGem, Thanks for the quick reply!! I'll give it a try.
(Lew on 08/08/08)
View All Comments
Ask a Question       View Past Answers       View Ratings            

Recent Answers from ScottGem
2008-09-29  The Error is You keep missing the point here. Again, both sides of the comparison have to be the same datatype. The expression sFilter = "[Date]= '" & Format(Me.fgh, "MM/DD/YYYY") & "'" will fail since Date...
2008-09-29  The Error is Yes that's part of it. The Format function returns a text string, yet you are comparing that to a Date/Time datatype. You have to make sure that both sides of a comparison are using the same datatype....
2008-09-29  The Error is OK, That tells me the problem and it should tell you as well. That means that you are mixing your datatypes. It looks like you are comparing a date value to a text string. there may be other places...
2008-09-29  Access Error I've asked you a couple of times now, what is the error message? If I know what the error is, I may be able to diagnose the issue. The code snippets I gave you should work. Hope this helps, Scott<>...
2008-09-26  Access Error But what IS the error? Also I would di like this Private Sub Command20_Click() Dim sFilter As String sFilter = "" If Me.ListFilter.ListIndex <> -1 Then sFilter = "[Assigned To]= " & Me...
More Answers for "Data Management & Storage"


Advertise on This Site | User Agreement | Privacy Policy | Kids' Privacy Policy
Copyright  © 2008 All rights reserved. AllExperts is a property of About, Inc.
The About logo, About and About.com are registered trademarks of About, Inc.