Search results

Hello - I'm tying to do a mass update adding notes to our Access 2007 database, but I'm running into an issue - I am matching an empyee ID worksheets up with our master table in access 2007. i would like to add a note that say: Date: Batch update: subj is part of upgrade project. subj has...

Hi all - I just updated a field in our master database with people DOB that matches their emp ID - I need to do a mass update in the comment field that say "Updated on 4-4-2011" but does not delete the the current comment that is already there in the comment field - i'm not sure how to go about...

Hello - I working of a store procedure in access and i'm tying to update 3 addition fields to a table called tblapplicant. I already added the fields in the tbleapplicant - but when i modify the procedure the 3 new fields which [CVS SOB],[CVS COB] and [PLACE OF BIRTH], would not update into...

hello - I have table 1 and table 2 - both tables have the same fields however in table 1 they have state of birth, city of birth and place of birth - and table 2 have the fields but it's all blank - i would like to update or insert the state of birth, city of birth and place of birth from...

Hi - is there a way i can nest an IF statement with 4 criteria? in my access2007 i have a field called dateuse => DateUse: IIf([DATE1] Is Null,[Date2],IIf([DATE1]>[Date2],[DATE1],IIf([DATE1]<[Date2],[Date2],[DATE1]))) Then i have a another field called Type => CCB CCB-PR SSB SSB-V then i...

Hi - I have a table with 2 different dates fields - and i can't get it to show me me the date I would like to get the query to run something like this -- IF Date1 is GREATER then date2 use date1 IF date1 is LESS then date2 use date2 if there is no date1 use date2 right now it's only...

Hello - I'm not sure if i am going about this the correct way... I have a table with 2 different date fields - 10years date and 5years date - i would like to combine the 2 fiels to one and call it ALLdate: so this is wha i would like to have the final result to look like Field:10yrs date...

Hello - I have a query appending to a table called tblCompDate In the query I would like my tblCompDate to show me a column called Date_Report and in the Date_Report column I would like it to use Completion_date PLUS 10years THEN minus 6Months to be the output of the date. so for...

how can I set the Date function for user to enter a date to generate the data? i have a make-table query - and in that query each day we have to change the date (, #3/4/2011# AS CAP_DATE) to yesterday date is there a way we can have the query or set it to read yesterday date? and if it's...

Hello - I'm tying to INSERT information from HRM table into HRM_final table and i am getting an error asking me to enter a Parameter value. I'm still very new at this access stuff - any help/suggestion? DoCmd.RunSQL "INSERT INTO HRM_final SELECT HRM.SSBN, HRM.title, HRM[ORG code] FROM...