Search results

I have it updating now, still with the problems from last post though, I need to tell it to reset to "no" now and updatet (LastActivation) to today (or whatever the day it was updated)

Ok, I have it somewhat working. The first query shows -1 if due and 0 if it is not due. The field is a Yes/no but it is not returning yes or no, it is returning those values. I guess I could use these values to continue making the queries but I would rather stick with yes not. Also, it is asking...

I have cascading combobox that fills in 7 txt boxes. I have a query that does that. I have two calendars and I want to have the selected dates be 2 fields on that same query that way I can use that query again to show a report based on the combobox selection and the 2 dates. (the records on and...

If the expense is due again, then it should say yes. I can't get it to say yes. the six records are the only records I have (just trial records) and I run the query and if it is supposed to be yes they show up, if no they don't show up, that is sorta what I want but with the criteria yes/no...

I am posting my whole database to hopefully make it more clear what I am doing. Under queries, Query1 and Query 3 are the ones that we are dealing with. The first one selects all the "monthly" expenses and the 3rd one is the one I am trying to have update. I will make it update from the...

yes it has been updated (off the update query) or no it has not been updated

That is true, and now at least with the -1,0 it runs. Depending on the < > direction it either shows my 6 records, or none at all. I think it is running correctly but it is not updating the yes no correctly.

I have not really messed with the query since thursday, I am working on it now...The reason I wanted to do just a normal query at first is to test to make sure that the query would draw the right records. If it did, I would just change it into an update query. You are right with what you are...

Ok, a friend of my was on my laptop and he crashed the hardrive. I was able to get the database I have been working on off the computer but when I use my computer at work to try to open it, it opens but says "Function is not available in expressions in tabel-level validation expresions" on all...

I have attatched what the form looks like right now, maybe this will help with ideas and show what i want to accomplish. Please help, this thing is due very quickly :eek: :o Explanation on top right of form I have the Employee Information (top left of form) based on a query, then I have based...

Ok, on click how would I run a sql statement? The only options are code, macro, or expression? Just run a DoCmd. RunQuery? Also, I want to put a date range in there to chose what metrics to look up. How can Ido this in the query without making it parameter? on the form I have 2 datepickers to...

Sorry, I don't know how I posted the same question 2x's but the other post has more to say about this. I tried that and it does not work for reasons in the other post. Maybe a moderator could delete this duplicate thread

Thanks, but when I run it it says Data type mismatch in criteria expression... Ok, figured it out, The "DueToday" field is yes/no not text...How do I fix this problem (I know how to change it from text to y/n but will that affect my following queries? I have changed things around and it will...

I just need to know how to compare 2 dates in an if statement: IIF (LastActivation) >= (Date()), (DueToday)= "Yes", (DueToday) = "No"

I just need to know how to compare 2 dates in an if statement: IIF (LastActivation) >= (Date()), (DueToday)= "Yes", (DueToday) = "No"

(IIf(("NextActivation")>=("Today"),(("DueToday")="yes"),(("DueToday")="No"))) If I understand u correctly need this turned into a Where clause? I am looking it up right now. This does run but nothing is shown in the query.

I have yes/no default to no (using 1 less query) because it is not due on the entry date. If (nextactivation) is >= (today) then yes/no = yes,0 I know u said don't use the if but I don't really know much about the where...Now on to what my question was b4 edit. Please let me know if this is...

Nevermind about what I had I figured both of those out so far. Thanks Oh, sorry also for all this work on your part. I am obviously a newbie at this and really, really appreciate your patience! A quick question. I have my first query like i want. It shows the original entry date and then the...

Thanks, Sounds good. After the query I just base the subform on the query correct? Or do I make 2 different queries one for the form, one for the subform. What I have is one dropdownbox that fills in 4 other text boxes, then the user selects (from a different table) a Metric (just a name for a...

Allright, found a good link for all that are like me: less informed, search impaired... http://www.mcse.ms/archive163-2004-9-1106658.html