Search results

But the data is used different ways in the 3 different tables. KPI Rating Criteria table has the criteria code and their descriptions. (this is the table where I ideally should have an autonumber field so each criteria code has a number associated with it. That way, in other tables, I would...

Thanks for writing. You're right, I should have Criteria Code as a number (instead of Text) and then use that number when needed. But I had help from someone who told me: "Create a query joining the two tables. For example: SELECT Table1.Field1, Table1.Field2 FROM Table1 INNER JOIN...

thanks for writing. your database looks great. but i don't think i can use that because i need to add an 'or' statement for my query. Please see attached database that shows what i'm trying to do. The Form frmEscalationReports has a combo box. I'm trying to build a Where statement so it pulls...

Hello, Just following up to see if anyone can help me. Thanks,

I have a table with 2 fields that looks like this: ReportID CriteriaCode 1 ...........Cost-R3 1 ...........Cost-Y6 2 ...........Sched-Y7 2 ...........Sched-R3 2 ...........Risk-R5 etc. I have a report based on a query. The query contains a field called CriteriaCode. I have a combo box on...

I'm using Access 2003. Can I compare data in a table and look for changes depending on the date? The primary key in my table is a combination of ProjectID and AsOfDate. My AsOfDate is always the last day of the month (ex: 1/31/08, 2/28/08, 3/31/08, etc) Ex: my table looks like: ProjectID...

I just opened my table in Design view and changed the field name. Then, I went into one of the queries and, to my surprise, the IIF statement updated automatically with the new name! I didn't know Access did that! Access 97 didn't do it. So I don't need any global search and replace afterall...

thanks, I'll try it from home.

Bob, thanks! i checked out the website. This seems good also: Work on Queries: Using this tool, you are able to work on SQL statement for all your queries in the same time. Search for a string or perform a 'search and replace' in all the queries. But I am at work and can't download. Also...

You wrote: "No but you could write one to do so. " How? Thanks,

I am using Access 2003. Is there a global 'search and replace' function in Access? I inherited a database with descriptive field names. If I change the field name in my table, is there a function that will search all the IIF statements in all my queries to change the name there...

I have lots of IIF queries that use IN and they work fine. I know I can do: iif([Lifecycle] in ("MS1-BeginPhase", "MS2-DesignPhase") I was trying to use LIKE with IN to simplify. I was trying to make this work somehow: iif([Lifecycle] in (like "MS1*", like "MS2*")

Thanks to everyone who wrote. ajetrumpet: I'm not sure how I was vague. I wrote exactly the IIF statement I was looking for. Crey23: Your way doesn't work. You can't do: Iif([Lifecycle] like "MS1*" OR like "MS2*", ....). I would have to write: Iif([Lifecycle] like "MS1*" OR [Lifecycle] like...

Can I use the IN keyword with LIKE? I know I can do: iif([Lifecycle] in ("MS1-BeginPhase", "MS2-DesignPhase") and I know I can do: iif([Lifecycle] like "MS1*" or [Lifecycle] like "MS2*" But can I do something like: iif([Lifecycle] in (like "MS1*", like "MS2*") Thanks,

Thanks for writing. The data is entered on a web form that asks Project Managers about 100 questions about schedule, cost, risk and scope. The raw data is put into Excel and then copied into Access. Depending on what the Project Managers answered on the web form, they get different codes...

Perfect again!! You're the best. It works great. Thank you thank you thank you thank you :-)

How can I make a running total so after running all the append queries, a message box appears that says: msgbox ("There were " & x & " append queries that ran and you have appended " & y & " records.") Thanks,

Mile-O, Perfect. That works great!!! Thanks a bunch!

I was trying to show that all my queries started the same, with the words 'AppendCritiera' and then a changing value. I guess my main question is, does Access assign a 'behind the scenes' name to each query depending on its position in the query window? So would Access assign the first query...

Thanks for writing. Would I have to type each query name in the "MyQueryName" fields?