Recent content by lordgeeuk

Ive tried using w like it suggests but it doesnt seem to be calculating weekdays but weeks, but weeks is suppose to be ww. =DateDiff("w",[Date Query Raised],[Date Contacted Customer])

Hi I have a Text box that stores a date of when a problem or query is received on to a customer account, when resolved the date it is resolved is inputted in the next text box as a resolved date. My third Text box then needs to display Yes or No depending if it took less than 28 days to resolve...

So Im confused, the best way is to import all the data into a temport update table then an update query from the update table to the permanent table?

This is being used by people with relatively no access experience so Scotts would be easier for them to be honest. Ive created the query but the expression says it contains to many brackets. Should it look like this? Keyfield: Str([Site Reference Number]) or Keyfield: Str[Site reference Number]...

Does the Keyfield: Str([keyfield]) go in the criteria or where im not 100% what you mean? I then use the query as a base for the query update?

Ahhh I see. Where would I use the expression?

Well Im getting there, I got the spreadsheet as a linked table and a update query from the spread sheet of the fields I want to update into my main table but Im getting a Type Mismatch in expression in my update query. Ive narrowed it to two fields from the linked spreadsheet, it imports these...

Hmmm Im a bit confused l presume I link the table to the spreadsheet? Ive tried that and it then only contains whats on the spreadsheet, loosing records that arent on the spreadsheet. Can I link the spreadsheet to the update query?

Ive looked at linked sheets but the problem is this: Ive designed a table based database that records all customer info balance, account number address general stuff, and field called query. This is where we record problems customer has on the account, how we deal it with it. Also there is a...

PS its only certain fields I need to updte not the whole record.

Hi Im quite new to access, but Ive got a little database running thats contains balances of customers account over 30 days 60 days etc and logs querys on there accounts, Im given a spreadsheet each week which shows that the customer may have paid something to their account so I need to import...