Calculating prior Query fields
Inside my query, is four listed fields; date, printer, and a Start and End meter for daily meter readings to keep track of printer impressions. I’m trying to receive a return value by subtracting a meter reading from the START field in a current row and the END meter in the previous row depending on [...]

Answer Question   |  May 13, 2009  4:24 AM
DLookup, Query optimization, WHERE statement

DoCmd.OpenReport not working right with WHERE clause
I have looked all over and seen hundreds of questions about this command, but no answers. It seems like the most basic thing you can do with combo boxes, so I’m baffled that it doesn’t work. Here is my VBA Code: Option Compare Database Private Sub cboFundNumbers_AfterUpdate() Const strFormName As String = “Fund Number 2″ [...]

Answer Question   |  March 18, 2011  10:20 PM
Access 2003, DoCmd.OpenReport, Microsoft Access 2003, VBA, Visual Basic for Applications, WHERE statement

How to find a specific word in a SQL table
How do you write a SQL query to find a specific word in a SQL column. Example: I want to show all records that have the word Bob in it but do not want to include records that are Bobby or Bobble etc., only the exact word Bob. Hope that makes sense.

Answer Question   |  April 18, 2013  3:13 AM
SELECT statement, SQL, SQL Query, WHERE statement

Query won’t access open form field for parameter
I want to open a group of receipt forms using the “client ID” from the open form “Client” as the parameter. I created a button which runs the “openform” action macro using “[Client ID]=[Forms]![Client]![ID]” as the Where Condition. This was working until I closed the access program and reopened the next morning. When the macro [...]

Answer Question   |  January 16, 2009  9:13 PM
Database programming, WHERE statement

Using the SQL IN clause in SQLRPGLE
Can I use a variable with the IN clause in an iSeries SQLRPGLE program? Can I use: WHERE CUSTID IN(:CUSTNUMS) Instead of: WHERE CUSTID IN(145,1600,352)

Answer Question   |  December 19, 2008  10:09 PM
IN statement, iSeries, iSeries development, SQL statements, SQLRPGLE, WHERE statement

oraoledb non working WHERE clause character comparison
Are there WHERE clause character comparisons that do not work when using oraoledb? I have a SQL query that is well formed and works with both Oracle 9 and Oracle 10g client, but will not execute when parsed via oraoledb.

Answer Question   |  December 11, 2008  1:47 PM
Oracle 10g, Oracle 9i, OraOLEDB, OraOLEDB.Oracle, SUBSTR, WHERE statement

SQL SERVEUR 2005 SISS AND WHERE statement
I create a SSIS to transfer the date from AS/400 TO SQL Server 2005, and it’s work fine. when I go to modify it and I add a where statement to choose only the year 2008, I received the following error code 0×80131937

Answer Question   |  December 5, 2008  5:24 PM
Error 0x80131937, SQL 2005, SQL error messages, SSIS, WHERE statement

How can I join 3 tables using JOIN keyword
Hi Experts, Pls hlp me with my query How can i join 3 tables using JOIN Keyword inside PL/SQL block in SELECT … WHERE clause Query 3 Tables namely Reg,ROOTS,ME and the select statement takes both parameter variable and local variable Thanks!!!!!

Answer Question   |  December 8, 2008  6:20 AM
JOIN statement, PL/SQL, SELECT statement, SQL, SQL Query, WHERE statement

.NET Question
In Window Application of C#, I want to generate crystal report with cases by using where clause and datagridview…? How it is Possible…?

Answer Question   |  December 1, 2008  12:25 PM
.NET development, C#, Crystal Reports, DataViewGrid, WHERE statement, Windows development

SQL select
SELECT obj.object_type FROM apps.opt_log_issue log, discov.opt_changed_database_objects obj WHERE –(UPPER(log.resolution(+)) like ‘%’||obj.object_name||’%’ – and trunc(log.resolution_date(+)) – trunc(to_date(substr(obj.last_ddl_time,1,11),’dd-mon-yy’)) <=5 – and trunc(log.resolution_date(+)) – trunc(to_date(substr(obj.last_ddl_time,1,11),’dd-mon-yy’)) >=0) OR (UPPER(log.resolution(+)) like ‘%’||obj.object_name||’%’ and log.resolution_date(+) is null) /

Answer Question   |  December 1, 2008  11:09 PM
Oracle development, Oracle SQL, SELECT statement, SQL Query, SQL statements, WHERE statement

Ignoring fields in SQL Where Statement
Can fields in a where statment be ingnored. Such as Where name = :name and date = :date, but if I just pass in a name I’d like the where to select only on the name and ignore the date.

Answer Question   |  November 3, 2008  8:13 PM
SQL, SQL WHERE statement, SQL/400, WHERE statement