Where may I find out which SQL sentences/queries are availabe in MS Access?
396944
Access 97 supports only limited SQL queries. Most of these can be generated with the query designer functionality in Access, but if you want to access the database using more advance SQL commands, try writing a VB program to do it and use an OLEDB jet connection. Then you get whatever functionatily you want on it.\nGood luck!
1106469
Use the 'Query Analyzer' in Acess to select each field from each table then go to SQL view to copy and paste the SQL code you need.
882395
a) select <fields> from <table> where <date_field> >= '2006-01-01' and <date_field> <= '2006-12-31'\n\nb) select <fields> from <table> where <date_field> >= '2006-09-01' and <date_field> <= '2006-09-30'\n\nc) select <fields> from <table> where month(<date_field>) = 11\n\nd) select <fields> from <table> where <date_field> >= '2005-05-15 02:00:00' and <date_field> <= '2007-06-04 15:00:00'
72709
It's been a while since I've played with Access, but what you're asking sounds right.  As long as the query is looking for the data in the same table, it should produce the same results.  I've never tried this, but it makes sense from a theoretical point of view.  Hope it works for you!
650047
What does "hit all of the control form fields and report the information back to SQL" mean? \n\nDo you mean, you want a button that will run a given stored procedure on the server, using parameters?\n\nDo you mean, you want to obtain the value of the form fields and use them to build a SQL statement that you then execute on the server?\n\nAlso, are you using SQL server, MySQL, SAP, whatever as a SQL database?\n\nUPDATE:\n\nYou still haven't told me what kind of DB server you are using, so I'll assume is SQL Server.\n\nYou don't need to create a VBA Script to do what you want. You can simply link the relevant SQL tables in your Access project file, then work with them as though they were tables in the Access DB itself.\n\nIn other words, you can build a form based on a linked table, just like you would build a form for a regular Access table; it will insert data for you into the linked table, the same way it would for a regular table.\n\nSee link below for more information.
126717
Access has limits in it's database it's not ment to be a bussiness database thats what sql is for...\nhttp://databases.about.com/cs/tutorials/a/widgetmenu.htm
696438
I'm missing something from your question.\n\nYou can always test your query in query analyzer.\n\nYour query looks fine but my confusion is in your where clause - if xxx is coming from the textbox then it sounds like you might generate the following query:\n\nselect * from table where bob like '%@bob'.\n\nWhen you probably want the following:\nselect * from table where COLUMNNAME like '%bob'\n\nnote:  I removed the @ symbol from your sql statement.\n\nAlthough you're better off creating a stored procedure that accepts a parameter using the field value as the parameter.\n\nIf you have any questions feel free to send me an email.
1007417
Hi..\nCheck out the following page...this might provide your some insight on Query Optimizations...\nhttp://www.sqlsummit.com/Optimization.htm
459913
Excel has that limitation.\n\nLook into using MS Access instead.
271292
Yes.\n\nhttp://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx
974290
I don't know of any tools to allow you to work the same way you do in Access, but if you want to do your queries in SQL, see your tables, etc, there are some tools available.\n\nYou have Entreprise Manager and Query Analyser for MS SQL Server (at least in version 2000, the one I use), for MySQL you have Control Center and Query Browser. \n\nCheck this link on query browser:\nhttp://www.databasejournal.com/features/mysql/article.php/3459931\n\nand this one on Control Center:\nhttp://www.lesbell.com.au/Home.nsf/438ebfdb9993616d4a2565d0001a90a1/2c5183e8974ccef8ca256e2900250697?OpenDocument
331868
Can you post a copy of both bills so I can put them in Access and run a compare query on them?
828970
dim db as database\ndim rs as recordset\ndim strSQL as string\ndim strA as string\ndim strB as string\ndim strC as string\n\nset db = currentDB\n\nstrSQL = "Select fieldA, fieldB, fieldC from Table1 where FieldD = fieldvalue"\n\nset rs = db.openrecordset(strSQL, dbOpenDynaSet)\n\nif not rs.EOF then\nstrA = rs!fieldA\nstrB = rs!fieldB\nstrC = rs!fieldC\n\nend if
99695
What do you mean?\nMaybe "SQL command with two criteria?"?\n\nIn this case if you mean the condition "WHERE" you joint each condition with "AND".\nExample:"SELECT * FROM table WHERE field0 = 'value0' AND field1 = 'value1';"
109395
What you need to dig into is SQL for database inquiry and update.
919441
Two SQL statements, which you can enter in SQL view in the Access query designer.\n\nIn these statements, col1 is the greater column, col2 is the lesser column, and table is the name of your table.\n\nSELECT col1, col2, (col1 - col2) AS profit FROM table\n\nFor the sum:\n\nSELECT SUM(col1) AS col1sum FROM table
508660
"SPONSOR RESULTS" when inserting "tutorials on MS Access" into Yahoo!'s Internet search:\n\nMS Access Tutorials \nwww.customguide.com Online Access training and matching print on-demand courseware.\n\nMicrosoft Access Tutorial CDs \nwww.teachucomp.com Master Microsoft Access with this comprehensive tutorial.\n\nMS Access Tutorial - Video Professor \nwww.videoprofessor.com Official site. Free beginner and professional Microsoft Access online training.\n\nThere were 3,150,000 other results in the listing that came up with that search.