Re: Display field of selected record from full table recordset

2004-07-25 Thread Justin Swanhart
You probably want to pick up a good SQL book. MySQL by Paul DuBois is a really good one. http://www.amazon.com/exec/obidos/tg/detail/-/0735712123/qid=1090786499/sr=8-2/ref=pd_ka_2/102-0741496-3072118?v=glance&s=books&n=507846 You want to use the WHERE clause of the select statement. SELECT tabl

Display field of selected record from full table recordset

2004-07-25 Thread Robb Kerr
I have a recordset that retrieves the full content of the table - all fields, all records. Depending upon the content of different fields in different tables, I need to display certain fields of certain records within the full recordset. What's the syntax for selecting a particular record for displ