Search results

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...

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...

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...

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...

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...

Okay Maybe i am totally confused but here is initially what i have and what i want to do. I currently have a db for carrer development-- i have three fields Last Review Date Next Discussion Due Status My next discussion due is on the fly-- i did a dateadd (by one year) from the last review...

Good Morning :rolleyes: I have a complicated question here. I am currently building a db for career development in my workplace. The main fields that i am having some issues with is the following. I have three fields labelled as the following: 1) Last Review date 2) Next review date ( i...