Search results

Hi all I'm trying to create an extra field in my table with a "month/year" data so its easy to group the data its a large amount by the way....this is the field I want to convert "ARRIVAL_DATE_TIME" 19/06/2009 14:31:00 The new field would be "ARRIVAL_DATE_MONTH" 06/2009 (mm/yyyy) I've...

I have a monthly report I run, the process is I have about 10 excel sheets each with its own macro I go into each excel sheet to refresh the data through running the macros. I'm looking at speeding this process up by having one excel sheet that opens all the excel sheets refreshes the macros...

Hope someone can help so here goes, I have a data quality database I run on a daily basis, however I keep having to go into the database query to amend the date everyday my object is to try automate this a much as I can i have tried this. "ADMISSION_DATE_TIME" is the field ">=TODAY() And...

Initials____Forename J y________ John Henry Left([Forename],1)+" "+Right([Forename],1) I'm processing a survey and trying to Update Initials field on a query and have used this query above but the update that comes up is as above, I am required to put both initials on the field can someone...

I'm creating an excel sheet for one of my dep heads hope someone can help so here goes. What I want to do is when a user enters the date on the "referral date" field a code that auto populates the "referral month" field like example, hope some one can help its doing my head in arrgh all this is...