Recent content by wish24bone

All, How can I run multiple update statements that join to other tables, using 1 sql script? Here is the query I have now that is failing.. Ideas? UPDATE EXCEPTION SET [exception].[assigned to] = [UserInfo].[Name] IIF( [exception].[Assigned_to_id] = [UserInfo].[id]), IIF(...

Hi all, I have 2 tables, on the 1 table, I have a field I need updated from another field in another table.. so tbl1.field1 needs to be tbl2.field2 both are text fields. The problem I'm faced with is that my criteria is the following.. tbl1.field1=tbl2.field1 tbl2.field1 is a number field...

Hi all I have an issue where I'm trying to find an id in a table and then also pull back that table name the id is in.. I have about 6 tables in my database, I have to search through each table looking for an ID value.. I would like to be able to have my query retrieve the ID as well as the...

Thats it!!!! Thank you very much for your help..

Ok, I had other issues related parens. I fixed that and can get the query to run but it's not working right, it's pulling back the past 3 days and today isn't monday.. In your reply you refer to the ,2 as the problem.. but don't I need to have that to determine if the current date is monday...

Ok, I think I see what you mean.. I now get a malformed query error.. I think its how I'm determining the day of week.. Here is my query SELECT Count([EDI Request Form].ID) AS Expr1 FROM [EDI Request Form] WHERE ((([EDI Request Form].Modified) >(date()- IIf((WEEKDAY(DATE(),2), 3, 1))) AND...

It's 1 table, the 2 select statements I want to run based on what day it is, will pull look back a certain amount of days.. IE. If today is Monday then the true select would have a select that has a where condition that looks back 3 days to report data.. if today is not monday, then the...

I was wondering if it was possible to write an IIF query, that depending on the day of the week it would execute specific select queries that I could then return in a subreport form. something like: IIF(WEEKDAY(DATE,2),<ON TRUE RUN SPECIFIC SELECT>, <ON FALSE RUN A DIFFERENT QUERY>); Then...

Thank you, that worked

Hi, I have a table with a number field that is set to display as a %.. (ie.. 100 displays as 100.00% when the column is selected).. I want to not see where the value = 100.. my query ---------- SELECT [SmartAdvisor Infrastructure Request List].[% Complete] FROM [SmartAdvisor...