Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #54.9K
|
hello all i m new to this topic, though I have some experience of using VB to control excel. I have an access database which has some records. The columns(fields) are first name, lastname, year of birth, city, county, district, state, tel ph number and email id. Now I want …
|
|
Re:
SQL Query
Hi, When using the following SQL query I get back just over 12,000 records. SELECT JobNumber FROM myTABLE; There are alot of duplicates within the records. I am wanting to only get back one of each JobNumber. If I use SELECT JobNumber FROM myTABLE GROUP BY JobNumber the number of …
|