Search results

raskew - I created a new "module 1" and entered the function code. I then went to my query and entered the code in the Field section. However Access says the expression is invalid and highlights fNextNthDay. Any suggestions? Thanks, Jim

I am still really confused about how to do this. FoFa: Are you saying make the field value something like "6-Month Review Date: [Approval_Date]+180+Weekday 4" or something like that? Wednesday is weekday 4, but I am not sure how to incorporate it into the field calculation. raskew: Where...

Anyone have an idea? Thanks, Jim

Unless I misunderstand you, this defeates what I am trying to do. I am trying for it to automatically calculate the 6-month date then automatically round it up to the next Wednesday. I don't want to have to manually add extra days to get the date to a Wednesday. Any other suggestions...

I track reports in a database. I have a date field [Approval_Date] in the database table. I want to review the reports after they have been approved for 6 months to see if the actions fixed the problem, so I created a query based on the table and used the code "6-Month Review Date...

I am not sure if this is what you need, but here's a link to an image capture of the query. I basically want to update some fields in tbl_Data with data in tbl_Update Status. I appreciate the help. Let me know if you need more info.

Does no one have any ideas how to update data in a table from data in another table? I really appreciate any help.

That works! Thank you. Jim

A little update on my problem. I created a Make Table query to copy the data I am interested in updating down to my Access file. I then created an Update Query based just on the local table I created to update my main data table. But I still get the error message that the query is not...

I have an Access file with one data table and several linked (read only) tables from a mainframe database. I run an Append Query to import certain data from the linked tables into my data table. Periodically the data in certain fields in the linked tables will change. I want to refresh my...

I get an error message that says "The In operator you entered requires a parentheses". Your help is appreciated. Thanks, Jim

Thanks. Just to make sure, this can't be done in a form field...right? It has to be done in a query. Thanks again, Jim

Can you give me a few more specifics of how to do this? Thanks, Jim

I have a table that includes the following fields CAUSE_TYPE STATUS In a report, I want to count the CAUSE_TYPE if the STATUS is "In Progress". So for example, I want a report that has fields to show Number of "Root Causes" in progress Number of "Apparent Causes" in progress Number of...

I tried putting the code "[EVENT_DATE]+60" for example in the "Default Value" section of my "APPROVED_DATE" field on the form, but it never populates the field. Is my code wrong? I would like for the "Default Value" in the "APPROVED_DATE" field to be populated when I enter a value in the...

Don't get me wrong, I am not being negative. I really do appreciate the help. I was just hoping that the "Default Value" in the form field could handle this without having to create additional fields. I do have one question however, how did you get the dropdown to remember the default...

Is there a way to apply conditional formatting on a field based on the contents of another field? For example, lets say I have the following fields START_DATE APPROVED_DATE CAT# DAYS_OPEN The DAYS_OPEN field is automatically calculated in the query and is not a stored date. My criteria is...

I might can make this work. I was hoping there would be a simple solution. Thanks for the extra effort. I really appreciate the support on this forum. Jim

Thanks oldaf294 for your suggestion. Normally I would not store dates like these, however I have a need to. The reason is that the calculated dates are just "recommended" or default dates. I am using this database to track one time project dates. These dates must be agreed upon by the...

I have a form (frm_Active) that reads from a query (qry_Active) based on a table (tbl_Data). The form/query/table has the following fields: EVENT DATE START_DATE REVIEW_DATE APPROVED_DATE POST-REVIEW_DATE When I add a new record, I would like for the default dates to be populated based on the...