Search results

Hi All, I have just designed my first union query using help from various web sources. However, I seem to have run into a problem caused by my lack of database design experience. I have used two different lookup tables which in the single queries, work perfectly. However, when I run the union...

I have now resolved this by creating a union query. However, I have another issue now which I will post separately!

Hi All, I am fairly new to Access and only have limited coding experience (which I have had quite a bit of help with, so please be basic with any replies!!). I am developing a database for use in my workplace which is a training company. I have a table called 'Reviews', which tracks the last...

Is this what you need? SELECT [Contract Details].[Start Date], DateAdd("w",2,[Start Date]) AS [First Contact Due], DateSerial(Year([Start Date]),Month([Start Date])+7,Day([Start Date])) AS [Second Contact Due], [NVQ Details]![NVQ Actual End] AS [Final Contact Due], [Personal Details].[First...

Hi, DueDate is a Date/Time field so I assume that's ok. When I run the query I get all records so again I am happy with that. I am sorry but how do I get the SQL of my query?? I told you I was new!!! Ella

Hi there, I am tearing my hair out on this one as I know it must be easy but I am new to Access so am struggling. I have created a query which works out a due date for a specific task. From this, I want to be able to run a query/report, say once a week, which only shows overdue dates so I know...

Thank you both for your help. I appreciate you pointing out the differences between Access and Excel. I agree it requires a totally different mindset. It is amazing what Access is able to do (if you know what you are doing)...I fear I am turning into an Access Geek!

Hi All! I am pretty new to Access so I apologise in advance if this question is really basic but I can't seem to find any specific help. I work for a training company and am setting up a new Access database to track our learners. I have set up a table to show when their qualification is...