Recent content by ayh1

yep if i double click the report from the toolbar on the side it currently shows all

yes i have a show all button and filter button, the filter takes the show all report and limits it down

It would not work as it is linked to sql tables

I tried it with month only first it says error, expecting two arguments DoCmd.OpenReport "AttWholeCity", acPreview, , "([Month]='" & txtCourseDateMonth & "' OR IsNull([Month])=False)"

I have a report filter that filters the reports by month and year: DoCmd.OpenReport "AttWholeCity", acPreview, , " Month = '" & txtCourseDateMonth & "' AND Year = '" & txtCourseDateYear & "'" I want the code to also show these two columns where there are null/blank values aswell...

I have a query SELECT TOP (100) PERCENT CONVERT(char(3), dbo.tblCourses.CourseDate, 0) AS Month, YEAR(dbo.tblCourses.CourseDate) AS Year, gp.OrganisationCode, gp.Name, gp.Address1, gp.Address2, SUM(CASE WHEN a.AttendanceStatus IN (9) THEN 1 ELSE 0 END) AS Attended...

I have tried SELECT TOP (100) PERCENT CONVERT(char(3), dbo.tblCourses.CourseDate, 0) AS Month, YEAR(dbo.tblCourses.CourseDate) AS Year, gp.OrganisationCode, gp.Name, gp.Address1, gp.Address2, SUM(CASE WHEN a.AttendanceStatus IN (9) THEN 1 ELSE 0 END) AS Attended...

I tried SELECT TOP (100) PERCENT CONVERT(char(3), dbo.tblCourses.CourseDate, 0) AS Month, YEAR(dbo.tblCourses.CourseDate) AS Year, gp.OrganisationCode, gp.Name, gp.Address1, gp.Address2, SUM(CASE WHEN a.AttendanceStatus IN (9) THEN 1 ELSE 0 END) AS Attended, SUM(CASE...

When i select all rows from gp (right clicking on the link/join) it creates a right outer join but still the same results i tried changing all to right outer and no luck, then changed all to left outer and no luck

Hi I have a query: SELECT TOP (100) PERCENT CONVERT(char(3), dbo.tblCourses.CourseDate, 0) AS Month, YEAR(dbo.tblCourses.CourseDate) AS Year, gp.OrganisationCode, gp.Name, gp.Address1, gp.Address2, SUM(CASE WHEN a.AttendanceStatus IN (9) THEN 1 ELSE 0 END) AS...

Hi I have an access.adp project how can i password protect it I have looked for tutorials and it states encrypt via the File - Info tab but this option is not avaialble on .adp projects? is there an alternative thanks

its working thanks had year and month mixed up

i tried that but it does not filter as when i try each filter seperately it brings up all the records

Hi I have vba code DoCmd.OpenReport "MonthlyData2", acPreview, , " YEAR(CourseDate) = '" & Me.txtCourseDateMonth & "' " this works sucessfuly how can I add the following to the code so it filters month and year? '" MONTH(CourseDate) = '" & Me.txtCourseDateYear & "' "

if I send it to you it may not open correctly as its connected to sql server tables