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
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 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
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
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
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
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
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
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
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
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