Search results

Hi, I am trying to convert a text string into a date string, and was recommended to use a cdate() function. I tried looking at the web and the help function in Access, but could not figure out how to use it. I tried putting the Cdate function in a query, and I get an error message saying...

How do you use the cdate function? I tried putting the Cdate function in a query, and I get an error message saying "Invalid use of Null". I used the function like this below: CDate([STATUS_DATE]) I am looking to convert a text string into a short date, as in 1/1/2012. Thanks for any help.

This works well. Thanks.

Hi, In CSV, I have the date as 7/23/2012. But in an Access table, the date is 2012-07-23 and stored as a text. I would like to have the Access table to have the format 7/23/2012, so that I can run queries using the filter: between 7/1/2012 and 8/1/2012. FYI, I am linking the CSV file from MS...

How do I identify null values before entering the case statement? Thanks.

I have tried "" and " ", and both methods doesn't work. Thanks.

Hi, Does anyone know how I can read in a blank (or empty) cell and spit out an empty value? See my code below, as I have everything set up except for the null string. Option Compare Database Function cnty(x) As String Select Case x Case "Bronx", 5: cnty = "Bronx" Case "New...

I downloaded the query and VBA code from John K's database on the first page of this thread, and I have modified the query since then for other uses. Are you saying to compile the VBA code on my new PC? I have done that already, and no error messages. If you're talking about my old PC, then I...

I am running a query in the database called "qryTwo." The SQL code is below. I haven't modified the query nor the code. I only noticed the problem after I got a new computer, and tried running the same code and query. FYI, I still have access to my old computer, and it works fine. SELECT...

I open the "immediate window" screen, and compiled the code again with the debug line in the right place (see below). When I compiled, I do not see any output on the "immediate window." Debug.Print SQL ' open recordset. rs.Open SQL, cnn, adOpenForwardOnly, adLockReadOnly Thanks again.

I did try it yesterday, the query works well for two dimensional data. But what happens when there are like 3 languages (and more)? Do I set the query to have 3 columns, as in the group row, change to first, last last? Is there a feature where I can go first, second, third, ..., last? Thanks...

I tried your suggestions (see below), and when I compiled the code, nothing happened, as in I am guessing there is no error. But when I ran the query, I will get an error message, and I will hit the debug button. This takes me to the code below, with the "rs.open ..." line being highlighted in...

I tried putting the line into the section below, and compiled the code, I got the error message "compile error: variable not defined." As a FYI, I am thinking my new computer is missing some softwares/packet/updates. Thanks. See below for where I placed Debug.Print SQL Option Compare...

Thanks for the help, but when I try compiling, I do not get any errors. But when I run the query, I will get an error, and I will hit debug. And the section below is highlighted. rs.Open SQL, cnn, adOpenForwardOnly, adLockReadOnly FYI, I am using Windows XP 2002 and I have MS Access 2003...

A very good solution to a simple problem (can I use that query for 10 languages?), but my data gets more complex. A record can have over 10 languages, and I would like to have those records in over 10 columns. To illustrate with 4 languages, ID Language 1 English 1 Spanish 1 Russian 1...

Hi All, I need to transpose some columns into rows, so that I can unique records in my database. Here's an example of data I have: ID Language 1 English 1 Spanish 2 English 2 French Here's the output I want (notice I now have two language columns instead of one): ID...

I tried your method, and the setting looks the same when comparing my last computer to my new computer. FYI, another moderator in the queries forum has given me the solution below, but I can't quite figure out the instructions, and I am working with him to solve the issue. Thanks...

If anyone can write a better concatenate code than above, I will be happy to use the new method as well, since the current method does not fit exactly what I need to do. Here's the data I have: ID Language 1 English 1 Spanish 2 English 2 French Here's the output I want...

Thanks, I tried downloading the update package from the website below (after scrolling to the bottom of http://social.msdn.microsoft.com/For...6-34f11c6b5a13), but I can't open the file because it has an .msu extension. I was then prompted into the website below, but I don't quite understand the...

If anyone can write a better concatenate code than above, I will be happy to use the new method as well, since the current method does not fit exactly what I need to do. Here's the data I have: ID Language 1 English 1 Spanish 2 English 2 French Here's the output I want (notice...