Search results

Take the query apart? To test this, I made one simple table with two fields and a few records, NameID and a date field. When I try to update that table's date field with an update query I get the same error message. Isn't cDate used to convert field values? I don't need to convert this...

Yes it is a a date field.

Yes Pat I picked up on that right away and fixed it. From what I could see it needed 5 closing parentheses at the end of the expression. With that in place I get the data mismatch error.

When I create an update query on my select query then add the Roles table to it along with the field I want to update everything updates just fine but only when I type in the data (02/01/2013) for example in the update to cell. When I try the same thing with the date expression -...

The best way I have found to copy discs of any kind is through an outiside program such as Nero. To me Windows Explorer just confuses the fact.

Interesting. And they did it quite well.

Lots of things in films are bogus. Just like the internet.

Just as in everything else that causes problems it is the person, his attitude, poverty level and inner thoughts that determine what he will do. I once saw a bumper sticker that said "If guns are outlawed, can we use swords?"

The original Select query selects the person who has not had that duty the longest time ago. However, when the Update query is created on the Roles table it has no provision to select a single record and so returns more records than is desired. If I build the Update query on the original Select...

So, is it not possible to update a single record on my table with the results of a Select query?

If I don't use the Names table I don't know if the date field will be updated on only the one selected record. Will it update all records? When I run the update query it pulls four records, not the single record I want to update. I can move the "Active" field to the Roles table if necessary...

Pat, Just a bit tough for me to follow/create tables that match your SQL. Here is one of the Select queries that I'm working with. Names and Roles are tables. I would like to update the date field AnnouncmentsDate in the Roles table to the first day of the next month using an update query...

I've got several select queries that work well. What I would like to do is update the table's data where the query gets it's info with the results of the select query. Generally with update queries, it is required to type in some text in the Update To row. I want to have that row get it's data...

I've been working with databases since Paradox in DOS, and then went on to use Access. However, I am no whiz at it. I've made a few applications for various non profit groups and sometimes stumble around for solutions. :)