Queries

Error 13, Type mismatch...sometimes
Hi, I have two problems that I hope will share the same cause. First when the user enters data, (via our VB6 application), we sometimes get an error 13, "type mismatch" message box. but more worryingly the application sometimes hangs, (and we then have to restart it). I suspect it could have something to ... 5 Oct 2005 09:50

Problem with Nested IIF
I am trying to set up a query with a calculated field (let's call it [NoticeDate]) that contains a number of conditions. The query includes the following fields: [CurrentTermExp], [30Days'Notice], [60Days'Notice], [90Days'Notice] Assuming that [CurrentTermExp] Is Not Null (I've set the query up to filter th... 21 Sep 2005 01:42

How do I fix Access Error undefined function "CStr$" in expressio
I am using the 2003 Office Professional Package In running a query in Access the following error message pops up Error(3085) - Undefined function"CStr$" in expression. I have reinstall Access and it has not corrected the problem. Help! ... 20 Sep 2005 19:03

Select Data
Is there a way to use the LEFT() function to take all the characters until a space is encountered? I am trying to normalize data I imported from another program and the City State and zip are all in one field there are no comma's. I used Right() function to get the 5 digit zip code. example Honolulu Hi 96... 19 Sep 2005 16:32

Days, Weeks, And Months
I have 2 dates I want to know how many days weeks and months went by (for rental purpose) I did Days: [Date in]-[Date Out] and this gives me a flat number of days (26 days, 13 days, 93 days) but I want to know how many days, weeks, and months went by (Example: 24 Days = 3 weeks and 3 days, so 3*25 (weekly Rent... 18 Sep 2005 18:55

ODBC call failed
I am trying to run an append query and am getting the following error: [IBM][CLI Driver][DB2/NT] SQL0952N Processing was cancelled due to an interrupt. SQLState=57014 (#-952) I am able to connect to the ODBC driver in Adm Tools and have run this query before with no problems. Also, I have rebooted my PC to s... 14 Sep 2005 12:04

Computing Median
I need to compute the median not an average. Using help in Access 2000 it says there is a worksheet function "median". No there is not. It says undefined function when I try to use it. I have found the help in access 2000 to be totally worthless. It gives me answers that are out and out wrong. ... 13 Sep 2005 14:23

reverse crosstab
Hi, Does Access have the capability to "reverse" crosstab? I have a table with month (from jan to dec) listed vertically in the first column, and the day of the month (1 - 31) listed horizontally in the first row of the table. (The upper left cell in the table is blank). All the intersecting cells of this mo... 30 Aug 2005 20:20

INSERT Statement (Access)
I'm currently writing a Windows application in VB.NET using Visual Studio .NET 2003 and connecting to a MS Access database. The software checks SMS and Active Directory to see if a software license is available and, if so; writes the employee's name into tblSoftware for that instance of software. So let's say "M... 30 Aug 2005 18:16

pivot table
I can create a pivot table to show data from a query in the view that the user would like to enter the data into. However, the pivot table will not let me enter or change the data...the underlying query will let you enter or change the data (and if I change to datasheet view I can add/change the data. The use... 16 Sep 2005 14:43