Any NS out there familiar with writing the SQL code on Microsoft access? I am in a class for it right now which my advisor lied to me about and said there was no computer code writing or anything similar. Well this statement was greatly false!Anyways anyone who might be able to give me a hand pm me or something and of course +k if anything helpful is posted.
SQL Code Anyone? Help!
- Thread starter EASTIE21
- Start date
bermbuster49
Active member
google that shit up, shouldnt be too hard. I dont know much SQL, just how to create querys and execute them and work with the data somewhat. Oh yeah i mainly do that through PHP but i have done a project with SQL in visual basic this semester too
Justo8484
Active member
SELECT [field names go here, separated by commes] FROM [table name] WHERE [field name you want to compare] LIKE/= 'value to compare to field'
That'll spit out, say, all records where 'firstname' = 'John', etc. from there you basically just add on query params, unless you actually have to do joins and whatnot. also check w3schools. it might not be specific to using SQL in access, and is probably for MySQL, but the basics are pretty much the same, and if you're using access, i doubt you're doing anything more than the basics anyway. hope that helps!
That'll spit out, say, all records where 'firstname' = 'John', etc. from there you basically just add on query params, unless you actually have to do joins and whatnot. also check w3schools. it might not be specific to using SQL in access, and is probably for MySQL, but the basics are pretty much the same, and if you're using access, i doubt you're doing anything more than the basics anyway. hope that helps!
