antdickens
Programmer
can anyone give me a few pointers on the sysntac of sql select statements in access.
an example would be sweet
cheers
an example would be sweet
cheers
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sql select satement syntax
- Thread starter antdickens
- Start date
- Status
MichaelRed
Programmer
SELECT UNIBOND.ATFULL AS Team, UNIBOND.HOME_SCORE AS PtsAginst, UNIBOND.AWAY_SCORE AS PtsFor, IIf([Home_Score]<[Away_Score],"W",IIf([Home_Score]>[Away_Score],"L","T"
) AS WLT, UNIBOND.GDATE
FROM UNIBOND;
"Unibond" is the (single) source recordset.
"Select" is required
"From" is required
";" is required
Everthing between Select and From is the "Field" list, ALL of which are aliased (the "AS" keword).
The one 'complication' here is the use of the nested conditional. If this is difficult for you, just remove it completly (at least from your thoughts).
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
) AS WLT, UNIBOND.GDATEFROM UNIBOND;
"Unibond" is the (single) source recordset.
"Select" is required
"From" is required
";" is required
Everthing between Select and From is the "Field" list, ALL of which are aliased (the "AS" keword).
The one 'complication' here is the use of the nested conditional. If this is difficult for you, just remove it completly (at least from your thoughts).
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
- Status
Similar threads
- Locked
- Question
- Locked
- Question
