Search results

I've tried the above example, still a conversion failure.

So I should do the calculations within the query? Could I do something like: SELECT * FROM Table WHERE Date() > DateAdd('yyyy',1,[Last_Renewal]); ? Am I missing any characters in this statement? This is what gets me usually.

Hello I've built an an update query that updates a Yes/No field "Expired?" to "Yes" if the expiration date has passed i.e. if the current date is newer than the expiration date. I thought this would translate into the current date being greater than the expiration date? UPDATE Alert SET...

I have a query in design view that consists of two calculated fields at the moment. One of the calculated fields is supposed to add one year onto a value from another date/time field called "Last_Date." The expression I've written in the "Field:" box in Query design view is Expr 2...

What's that?

If I take "True" out and open the query, it runs the query, but there is no filtering effect. I haven't typed True in quotation marks.

Yes, I've removed everything from the criteria boxes, with the exception of "True" in the new one.

When I click the checkbox to Yes, I get an error message: The expression is typed incorrecly or it is too complex to be evaluated. This is the expression in the field box: Expr1: IIf([forms]![Find_Member]![Alderney_Only]=Yes,[County]="92",[County] Like "*" Or IsNull([County]))

Thanks. What I'm trying to do is put an expression in the criteria box of a query in design mode. The expression is based upon whether a check box "Alderney_Only" is marked yes or no in the form "Find_Member." If the check box "Alderney_Only" is marked "yes" (It is yes/no and not true/false?) I...

OK, so I assume the MS Access "Expression Builder" works in SQL. I understand the Expression Builder allows for conditional logic with the iif function. My questions are: Can you create nested iif functions like you can in Visual Basic? If so, how? Do you just replace value if true and...

I'm trying to create a dynamic query, that will change according to user determined parameters. I'm using conditional logic to define variables using Dim based upon values of controls within an MS Access form. The variables are defined as text strings. What I need to do is create a variable...

Long story short, a mistake has been made attempting to reinstall windows xp on an Acer Aspire T650. The computer came with a disk formatter DVD and two recovery DVDs 1 and 2. I reformatted the disk, so there is no operating system on the computer. Now I wasn't able to insert DVD 1 one prompted...

Many thanks, I appreciate that. Rather than start another thread, I also have another question please. Just Yes or No will do. Can you have multiple SQL statements within a single Access Query? Can I make a query that at once Appends rows to another table and then updates rows in the source table?

Thank you that worked. Thanks for your time.

Hello! I have a problem that I hope will be easily solved. I have an Append query that copies records from a table "Sightings" in one accdb file to a table "Observations" in another .accdb file. The Sightings table has the following fields: ID - Autonumber Species_ID - Number DD - Number MM...