Recent content by Tezdread

thanks PHV, I'm not sure where to put it but I entered it in the criteria area of the first query but when the results were shown they weren't what I was expecting? I have two queries, the first has this in the first column: DaysBetween: DateDiff("y",[Date In],[Date Resolved]) The second...

Adding on to the Avg query: What would be the best way to find out the average age of open cases, from the current date but only for that month? It's 31st March it will count back 31 instead of 28 if it's the 28th Feb I've seen in another post some way of counting back based on the month but...

oh really...that complicated ;-) Doh...I tried adding a new field to the same query and had this as the Avg as this seemed to be the logical option but didn't think to run another query from this one... thanks guys Tezdread "With every solution comes a new problem"

Lo all, I'm trying to create a query that will give me the 'Average' time it took to close a case based on the dates from [open date] and [closed date] I've got the DateDiff working (guess that's the easy part) but how can I incorporate the Average to get the value required? Hope this isn't...

thanks PHV, it looks like it would work...could you explain what's happening with it? I can see that if table1 = Yes it gets the value "Level" but what does the rest mean? Tezdread "With every solution comes a new problem"

Hi all, I'm having difficulties with a query (suprise suprise) maybe you can offer some help? I need the query to check values in a field and if the value is between 1 and 5 it should give a level1, if it's between 6 and 10 give it a level2, if it's between 11 and 15 give it level3 etc... I'm...

Thanks Michael, I might have to use the DLookup as I'm stuggling a bit with the query I'm trying to sort... Tezdread "With every solution comes a new problem"

I've got it working although not sure if it's the best way and I still need to be able to store the "yes" "no" field? This is what I have so far In the query I inserted all the fields that are in the iif statement then created the form based on the query. when I now enter the data into the...

Hi, I've been helped in getting a query to show yes or now based on the criteria specified in a table and I've now been trying various ways of getting this to automatically work on the form so when I finish entering details into the specific fields a text box will display Yes or No. In it's...

finally got it to work...thanks I think the penny just dropped as well....I was looking for information on the YNFlag thinking that this was a function of some sort but now I see it working it just looks like the name of the field the new Y/N value is stored. Tezdread "With every solution...

finally got it to work...thanks Is there anywhere I can find info on YNFlag? I did a search on google and couldn't fine anything there either? Guess it's not a common function Tezdread "With every solution comes a new problem"

still not getting there....I've done a search in help on YNFlag and it doesn't show anything, I tried putting it in a query, criteria but that didn't work either.... I'm not asking for a step by step guide but I just can't find anything in the help to point me in the right direction? Tezdread...

still not getting there....I've done a search in help on YNFlag and it doesn't show anything, I tried putting it in a query, criteria but that didn't work either.... I'm not asking for a step by step guide but I just can't find anything in the help to point me in the right direction? Tezdread...

ummm.....guess I'm missing some funamental information that I can't find in the help. I see the example and how it works now but where does it go :-) ? I tried it in SQL view but that didn't work and when i try different combinations in design view I can't seem to get it right eihther. I've...

I need to convert a few excel formulas into access queries and was hoping for some advise. :-) one of the simpler ones is like this If all these fields meet the specified criteria the outcome is Yes otherwise No field1 | Field2 | Field3 | Feild4 >= "2" | = "Y" | > "3" | <= "3" When the...