Search results

Okay-- so the box is not bound-- which is no big deal for me to bind it except for one problem-- this field i have it set to auto sum with the following: =DateAdd("yyyy",1,[Last Review Date]) is there anyway to still bind it -- The main problem that the users are experiencing is that they...

not sure-- if it is bound what is the best way to fix it?

Good Morning Hopefully this makes sense-- i have my db setup for employee development. What i have found is that when a new record is created within my form not all the information from the form gets updated into the table. The problem that this creates is that when my users pull a query for...

How would i go about locking the field-- i looked in the properties and am unable to find it

Good Morning I am attempting to apply a filter to a query i have setup. I only want the user to be able to search for specific words within two fields (technical and behvaioural) i have setup. I know i have to use a WHERE expression but am confused as how to exactly setup the expression...

Morning everyone I am stumped with a query i am doing. I have my query setup and a dialog box for my users to select their parameters for what they want to search fo. When i test it though-- and use the combo boxes the whole table comes up and not just the search criteria i have entered...

when i enter that i am getting an invalid error-- "you have entered an operand without an operator" any suggestions?

Hi I have a quick question about queries-- I currently have a query setup to show the status of users career reviews- (completed,overdue and upcoming)- i want my query to just show the overdues in the status field, rather than all users (currently includes the other users who arent overdue...

Thanks Doug It worked!!

hello i have the following expressions: Status: IIf([Next Discussion Due]<Date(),"OverDue",IIf([Next Discussion Due]>Date(),"UpComing",Iif([LastReviewDate]>=#11/1/2006# And([LastReviewDate]<=#10/31/2007#,"Complete"))) when i try to close my query and save i get the error of the expression you...

:o Okay Doug thanks BIG time for the help Here is what i have as an expression Status:IIf([Last Review Date]>=#11/1/2006# And ([Last Review Date]<=#10/31/2007#, "Completed",IIf([Next Discussion Due]<Date(),"OverDue",IIf([Next Discussion Due]>Date(),”UpComing”,””))) and the error that now...

I believe you're going to need a record for every employee that details each review date for each fiscal year. If you don't have that, any "Last Review Date" less than the current date will logically show up as "Complete", when what I think you're after is the date of the review - if any - for...

Keith. I am now getting an invalid syntax error for using overdue. Here is my exact expression...what am i doing wrong?? Status: IIf([Last Review Date]>=#31 OCT 2008#,"Completed”,IIf([Next Discussion Due]<=Date(),"Overdue”,IIf([Next Discussion Due]>=Date(),"Upcoming”)))

The above expression is exactly how i have it written in my query (which i assume is the wrong way to have it). I do not want completed to be a parameter... i just want it to show completed if the discussion happened in the current fiscal year. How do i incorporate that?

Exaclty-- now here is what i figured to do for the fiscal year-- but when i enter in this expression and i go to test it access puts the "Completed" as a switch function almost -- so instead of "Completed" it adds [] so i have to enter in a date for completed Status: IIf([Last Review Date]>=#31...

That is exactly what i am asking-- thanks... just need to kink out the formula....

Okay-- havent gotten an answer yet so will post again. Here is essentially what i am trying to do-- what i have done up to this point. I have a field which is listed as STATUS-- i want to be able to do a calculation for the one of the three following options to come up--Overdue...

Moniker Thanks for the help Call me stupid-- but when i use the switch expression like you suggested-- i enter in dates when prompted but by some weird reason the date that comes up in the status is now the day before the current day. Can i somehow change the dates to have the options show up...

Moniker First off thanks for the help. The switch expression looks like the possible way to go-- my only question .... how does it work with dates? It seems that it is easiest to work with this function with numbers but my fields have dates is there anyway around this??:rolleyes: