Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- 4TOPS Query Tree Editor for MS Access (exe)
- 4TOPS Query Tree Editor is an add-in for MS Access for query development. Create queries using templates. Edit and run queries from a tree dialog. The Query Tree dialog displays the dependency tree of the selected query (Uses / Used By). The buttons on the dialogs support a natural way...
- Tags: Microsoft Access, 4TOPS, Microsoft Corp., 4TOPS Query Tree Editor, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Software downloads 2006-10-09
- MS Access/Excel Query won't take variable as criteria
- I am trying to limit the imported data from an access table to the current day. The query wizard won't take a variable or indirect reference. When I build the statement in MS Query it won't take globals or system reference, only literals seem to work.Criteria:TableDateVariable >= TodaysDate
- Tags: Microsoft Office, andy@..., Microsoft Corp., Microsoft Access, Microsoft Excel
- Discussion threads 2007-09-11
- Microsoft Query
- I have created a sql query with table variables when I run the SQL in microsoft query it brings back the data, however when I try to return the data to excel it drops all the information & when I try to edit the query the SQL statement is blank.1....
- Tags: #SessionsByRegion, Microsoft Corp., Peter.mcauley@..., SessionsByRegion, software, SQL
- Q&A 2005-06-08
- FUZZY QUERY
- hi Any ideas of MS SQL and fuzzy query, is it similary to full text search available with ms sql 2000
- Tags: arbhagirathi@...
- Discussion threads 2007-08-06
- EMS MS SQL Query 1.1
- EMS MS SQL Query is a utility that lets users quickly and simply build SQL queries to Microsoft SQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows connecting to databases, select tables and fields for a query, set the selection...
- Tags: Graphical Interface, Query, SQL, Microsoft Corp., Databases, Programming Languages, Microsoft Windows, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Operating Systems, Hardware
- Software downloads
- QueryToDoc (zip)
- Export Query Results to Word or HTML. Use QueryToDoc to export Oracle and MS-SQL query results to a Word, HTML, CSV file. Write a SQL query against an Oracle or MS-SQL database, view the results, and then automatically export the query results to a table in a Word or HTML...
- Tags: HTML, Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software
- Software downloads 2007-09-19
- SQL in MS Access
- I am looking for help on a specific SQL query in MS Access. I keep running into syntax errors. I have 4 fields in the query. When the data I'm querying is LIKE the data in field 1 AND the data in field 3 and/or 4 IS NULL or BLANK,...
- Tags: Microsoft Office, Databases, kms_cryswater@..., Microsoft Access, Field 3, SQL, Microsoft Corp.
- Discussion threads 2007-07-02
- MS Word Mail Merge from MS Access VB
- Hello!I need to make serial letters with MS Word Mail merge from MS Access Query. This is very easy by using MS Word Mail merge wizard. But I need do that from Access Visual Basic routine.I would very grateful, If You could help me!ThanksAndreyTo do a mail merge within AccessYou...
- Tags: dr_avk@..., Microsoft Access, Microsoft Corp., Microsoft Word, MS Word Mail Merge, software
- Q&A 2004-11-10
- Query ASA from within MS SQL 2005
- I have data in ASA which I would like to query from my MS SQL 2005. Anybody got this right?Thanks in advance.Williehttp://www.cyberprop.com
- Tags: Willie@..., MS-SQL 2005, ASA, MS-SQL
- Discussion threads 2007-07-13
- how to optimize a update query
- i am using sql server , and try to update a table a single field with a update query " update table alpha set field1='23' where field2='asd'"now i have to run this kind of query 70 times/sec .Now in some cases query takes 7 ms to complete , but some...
- Tags: Databases, amitbharadwaj@...
- Q&A 2005-07-01
- Using Sybase
- What is the same utility in SQL Server 2000 like Enterprise Manger and Query Analyzer in Sybase?Where and how do I invoke these utilities?"Sybase Central" should be on the Sybase install CDs somewhere.You can use MS-Query or almost any SQL query tool to talk to Sybase.
- Tags: Databases, Sybase Inc.
- Q&A 2006-08-20
- Almost the opposite of duplicate query in MS Access
- I need to create a query that is almost the opposite of duplicate query in MS Access. It returns the lines that are not duplicates with one instance of duplicate line.Get to the SQL view of the SELECT query that gives you all the lines you want plus the...
- Tags: acampbell@..., Microsoft Access, Microsoft Corp., opposite, POSTER, SELECT, software
- Q&A 2005-02-21
- Export Query to Excel for Oracle (exe)
- Export Query for Oracle Server helps to save results of a query execution to Excel spreadsheet. The program supports has a few settings to make export more flexible. Export Query to Excel for Oracle has an easy to use wizard-based interface. All modern versions of Oracle Server and MS Excel...
- Tags: Oracle Corp., Program Support, Microsoft Excel, Microsoft Office, Storage, Databases, Office Suites, Software, Hardware, Enterprise Software, Data Management
- Software downloads 2008-01-15
- MS Access
- Hello All,I'm in a bind. For some reason, I can't seem to create a FORM in MS Access using two tables, that are related ID# on a single form. I get an error message that the Join Key is not vaild. Something to that effect. I've...
- Tags: anita.walker-dayle@..., ID#, Microsoft Access, Microsoft Corp.
- Discussion threads 2007-07-20
- MS - SQL
- I'm not Launch MS Query Analyzer from cmd promppt by keying in "isqlw". WHat would be the problem.
- Tags: Programming languages, ravii96@..., SQL, Microsoft Corp.
- Discussion threads 2007-08-09
- SQL in MS Access
- I am looking for help on a specific SQL query in MS Access. I keep running into syntax errors. Is there anyone out there that knows Access query?I am used to straight SQL query via a back-end connection like TOAD, so the restrictions of MS Access have me at a...
- Tags: Databases, SQL, kms_cryswater@..., Microsoft Corp., Paste SYNETICS PNs Here, LEFT JOIN, Microsoft Access
- Discussion threads 2007-07-06
- MS Access calculated field in report help!
- I have a report that is based on a query, where once I have the report grouped I created a calculated field, then I try to get the sum of the that calculated field , but it will not do it . It prompts me for the value for the...
- Tags: Microsoft Access, Microsoft Corp., norma.allen@...
- Q&A 2004-11-08
- How can I truncate data in a MS Access Field?
- Using Google, I found the following update query posted by Tony Hopkinson in Mar 2005:update mytable set ssn = right$(ssn,4)I tried this and it works for all MS Access databases that I have except for one. In that database, I get the following error when I run the query:Compile...
- Tags: Databases, Storage, joe.a.grabman@..., database, Microsoft Access, Microsoft Corp.
- Discussion threads 2007-04-16
- Append Query - "Type Convertion Failure" error???
- Have a simple form that is tide to a append query, neew to append a "master" table, query runs, show # records to be appended and then:MS error: can't append due to:A type convertion failure" There must be more to this diagostic...
- Tags: jxe07@...
- Discussion threads 2007-09-12
- << Previous
- page 1 of 1
- Next >>
