Search results

Hi all, I have a conundrum that's driving me mad! I have a categories table with 4 categories that are user selectable on the front end form (P, INCR, SP & VUK), I then have 4 tables that define various failure modes applicable to the categories (tables named FailureModeP, FailureModeINCR...

Hi all, I wonder if someone could help please as I'm stumped? I'm trying to produce a query that shows all records of patients that have a 'non-active' status (stored in the 'Patient Details' table) and haven't had any deliveries after 31/10/2011 (date stored in the 'Deliveries' table)...

Hi all, I'm trying to delete data (no archiving required) from 5 tables that all have a one-to-many relationship between them and keep getting the following error: "Could not delete from specified tables". I've tried everything I can think of including the following: * Set unique records...

I'm a SQL Server DBA and have a few Access 2010 Db's to look after and occasionally have to make amendments to (as is the case today). I've been asked to apply permissions to certain users of the Access database whereby users in a group we're calling 'Viewer' only have read permission and users...

***Update:- Just cracked this one by using T-SQL, if anyone needs the solution please just let me know, thanks.*** Hi all, I'm trying to create a query in Access 2010 based on a warranty_expiry field (data type: Date/Time) that will give me all the records where the warranty is due to expire...

Hi, figured it was time I actually joined the forum seeing as I've tended to get alot of the solutions to my Access problems from here! I'm entirly self-taught on all things Access, I'm actually a SQL DBA by day and a free-lance web designer by night (well evenings and weekends really hence...