Search results for query: *

yep, it worked. Thanks. funny that it wasn't a problem before, but now i know!

this must be a common problem, but I the solution i've used in the past is now not working. i'm trying to display a url from a db created in Access 2000. For ages, the following code has worked, but now in the past few weeks, I get an error message on my site, along these lines...

IT WORKS! Thanks for the helpful suggestion. The only change I had to make was to change <> to = for the purposes of what I was trying to accomplish, but it does everything that I need it to do, even in the rare case that I described before. I knew it had to be simple! Thanks again for your...

Thank you for your post. I tried it, but it said I had the wrong number of arguments. This was after I deleted one extra parenthesis you had which brought up an error msg.As for the nested query, and your suggestion, I think that if I need a second result to the if statement (the optional one...

yikes, somehow in my post, the minus (-) got deleted in my code. We're dealing with True/False. Sorry for the typo...

i'm new at sql statements in access, particularly nested ones. One trying to run an append query based upon a checkbox value. Here's what I want to accomplish. If the box is NOT checked, then I want to enter the value for CustID (from TblTransactions) into a certain field &quot;Owner&quot...

This may be more of a query problem, because I'm still getting used to using forms to update data and in Access I am only accustomed to the select queries, but less used to building insert/append queries in Access. What I want to do is this: while entering a new customer in the DB, I have a...

i'm somewhat new at access and have been using a particular db for awhile. the basic design is three tables: tblCustomers (includes contact info, etc) tblTransactions (links Customers to info on homes bought or sold by customer...a one-to-many relationship) tblAddresses (links the...