Queries

Text Date Field Query
I have a date field set as text. The filed needs to be text inorder for other processes to work. The data is entered in the format of 19750521, this is equivilent to YYYYMMDD. I am trying to write an anniversary query. In other words I need the query to pull the records (using the example above) for the cu... 6 Apr 2006 13:50

Calculating Elapsed Days
Hi, I have data like this 08/03/05 14:35:30.0 08/03/05 14:38:24.0 08/03/05 14:41:38.5 08/03/05 14:45:46.0 08/03/05 14:47:19.5 08/03/05 14:48:21.0 08/03/05 14:49:14.5 08/03/05 14:49:15.0 08/03/05 14:50:13.0 08/03/05 14:50:13.5 08/03/05 14:51:43.0 08/03/05 14:53:12.5 08/03/05 14:55:15.5 08/03/05 14:57:08... 6 Apr 2006 20:04

Update Query Must Use an updateable query
WorkLogID is Primary Key This DOESN'T WORK! (Operation must use an updateable query) --------------- UPDATE tblWorkLog wl1 SET DueDate = (Select Now() as field1 from tblWorkLog wl2 where wl1.WorkLogID=wl2.WorkLogID) This DOES WORK ------------------- UPDATE tblWorkLog wl1 SET DueDate = Now() The update ... 14 Mar 2006 10:15

Change field data type using query
Hi All, I have two fields in access table. One is MinVal and other is ActVal. I have imported this data from some escel sheet. Both the fields contain numbers. But while importing, the access filed data types for both the fields is 'Text'. Now I want to compare these two fields and update it as: ActVal=If(A... 13 Mar 2006 10:48

Query by dates
I have a query that creates a report for over due balances. For my date field I am using <=[Enter month & year in ##/####] as my criteria. It has work fine for several years, but now when I try to run the query for 02/2006, it said that there is no data, when in fact there is. Works the same for 03/2006. If I chang... 14 Mar 2006 09:44

Help with an IIF statement in a query
I have a query that runs off of a table with a yes/no field called [not_active]. I also have a form named [Comp_Report_Active_Criteria_frm] with 3 check boxes named [active], [inactive], and [both]. I would like it when: - the [active] check box is checked the query only displays records where the [not_active] b... 10 Mar 2006 14:25

SQL in VBA code ?
As I have found out, it is not possible to run a SELECT statement in vba using DoCmd.RunSql or DoCmd.RunQuery. But how can I then run a SELECT statement in vba ? -- My PhotoGallery www.photo.activewebsite.dk ... 8 Mar 2006 07:43

Between #date# And "date"
Using Access 2003 I am finding it impossible to obtain results when I enter the "between dates" format. I am using Access to search QuickBooks tables via QODBC. In an earlier version it worked. If I remove date parameters, it works. If I use the "looks like" feature on the year only, it works. But I need a ran... 14 Mar 2006 02:52

Create a simple search form
I've gotten over my head in a project that I have to finish. I've created a catalog for a small library with basically 1 large table that holds most of the book data. The users are NOT tech savvy, so I want to create a single field search form that will match any data in the table and return results. I've lo... 3 Mar 2006 19:40

Remove Data Outliers
Hello all, Using Access 2003. I have generated a database of construction production rates. Because of the data collection techniques employed, I need to remove a certain amount of the return data that can be identified as outliers. To do this, I would like to prevent the top/bottom X% from being viewed, not de... 2 Mar 2006 15:01