View Member - frankytee

July 24, 2008 07:19pm pdt

Experts Exchange

Announcements Feedback

1. hielo 4,968,592
2. angelIII 4,197,771
3. war1 2,797,136
4. chapmandew 2,750,516
5. capricorn1 2,379,989
6. KCTS 2,293,671
7. TheLearn... 1,964,674
8. rorya 1,886,318
9. zorvek 1,702,021
10. RobWill 1,466,532
11. b0lsc0tt 1,465,488
12. tigermatt 1,403,547
13. ee_rlee 1,367,953
14. RobSamp... 1,315,426
15. DatabaseMX 1,311,361

1. angelIII 22,960,218
2. Sembee 21,344,076
3. war1 15,614,832
4. jkr 11,092,614
5. TheLearn... 10,972,564
6. objects 10,468,166
7. capricorn1 10,063,762
8. lrmoore 9,416,458
9. zorvek 9,138,084
10. leew 8,772,329
11. byundt 8,556,216
12. ozo 8,243,972
13. TechSoEasy 8,135,840
14. CEHJ 8,125,907
15. Sheharya... 8,072,204

frankytee Login Name

Qualified Expert Account Type

691,109 Expert Points

10/16/2000 Registration Date

36,150 Points this month

Expert Certifications:

frankytee has earned the following certifications.

Guru

Master

Member Profile:

1992 BE (civil engineering), then changed to IT in 1995
vba/access/excel/sql server
2007, back after 4 year sabbatical from EE. I've noticed the points are far more generous than pre 2003, it was rare back then for points to be more than 100.

clients/employers who have payed my bills over the last 10 years ...
Capital Finance (Halifax Bank of Scotland) - 3 years current
CSR
Colonial First State
Flexirent
Harvey World Travel
Sensis
CSC - 3.5 years
DLJ Investment Bank London
American Express - 2 years .. good scenery
Honeywell
Australian Defence Industries

598 Questions Answered

	Date	Points	Title	Activity Type	Zone
1	07/22/2008	500	Adding condition in SQL	Assisted	SQL Syntax
2	07/22/2008	250	using distinct with filtered combo boxes	Accepted	MS Access
3	07/21/2008	250	Unbound text box to display data from …	Accepted	MS Access
4	07/20/2008	125	Iff function	Accepted	SQL Syntax
5	07/19/2008	500	SELECT, FROM, WHERE, REPLACE…	Accepted	SQL Syntax

606 Questions Participated In

2,645 Comments Posted

	Date	Points	Title	Activity Type	Status	Zone
1	07/23/2008	500	Why does this query produce an error?	Comment	Open	MySQL
2	07/23/2008	500	MS Access query	Comment	Open	MS Access
3	07/22/2008	250	Cannot Add New Record When Using …	Comment	PAQ	SQL Syntax
4	07/22/2008	125	How to get SELECT @@Identity to wor…	Comment	Open	MS Access
5	07/21/2008	500	HOW TO Create a Query to PULL speci…	Comment	Open	Access Reports

37 Questions Asked

2 Questions Open

28 Questions Graded

7 Questions Deleted

	Date	Points	Title	Status	Zone
1	07/02/2008	500	DTS ActiveX VBScript Shell and Wait for unzip …	PAQ	MS SQL DTS …
2	06/26/2008	490	can sql server 2000 send sms to mobile (c…	Open	MS SQL Server …
3	06/25/2008	500	sql dts failure DBNETLIB connectionread gener…	PAQ	MS SQL Server …
4	04/07/2008	500	How to rename DTS packages and ensure it ca…	Open	MS SQL DTS …
5	01/07/2008	500	sql server drop clustered property but retain pri…	PAQ	MS SQL Server …