Search results

Hello Experts, I have included a database that I hope illustrates what I am trying to achieve and what I have so far. What I am trying to achieve on the line graph is to show whether the “whatif” pattern either adds to the overall supply OR subtracts from the overall supply.... the main blue...

Hello Experts, I am using VBA to import an Excel spreadsheet, however i am getting the "Error!" in some fields from the spreadsheet. See attached. Does anyone know what the cause of this and how to get rid of it :banghead: Thanks greatly

Hello Experts, I have the following query saved as "Query6": "SELECT FlexiWorkers_PatternDistribution.Watch_ID, " & _ "FlexiWorkers_PatternDistribution.PatternValue, " & _ "FlexiWorkers_PatternDistribution.PatternStartDate, " & _ "MasterEveryone.WorkGroup, IIf([Start Time]...

hello all I have a query: SELECT FD.PatternValue, FD.Service_ID, FD.PatternStartDate, Count(FD.PatternValue) AS CountOfPatternValue FROM FWPD AS FD INNER JOIN ME ON FD.ID = ME.ID WHERE (((FD.PatternStartDate) Between #5/1/2015# And #5/5/2015#) AND ((ME.WorkGroup)="ATSA")) GROUP BY...

Hi experts, See attached database. I am trying to achieve a query that produces two column heads on a graph. i have tried a crosstab query but it is limited to a single column header.... is this possible? The first row would produce a list dates (dynamic in range) then above that the list of...

Hello all, I have a the following vba code for creating and populating a table: strCreateTableSQL = "CREATE TABLE WatchPatternDates " strCreateTableSQL = strCreateTableSQL & "(WatchDate Date NOT NULL PRIMARY KEY, " strCreateTableSQL = strCreateTableSQL & "Morning CHAR NOT...

Hello all, I have a form with a graph on, and want to show two different lines on the graph, sourced from seperate tables. The commonality between the two tables is a date. One line shows count of people available every 15 minutes and the other would should the demand for people on the...

Hello all, I have the following query: TRANSFORM Count([Copy of qryDailyCountOfValidations].Staff_Number) AS CountOfStaff_Number SELECT [Copy of qryDailyCountOfValidations].PatternStartDate, [Copy of qryDailyCountOfValidations].[End Time] FROM [Copy of qryDailyCountOfValidations] GROUP BY...

Hi all, I am trying to find the second to last date (max Startdate - 1) from a group of student attendances. Example: Id Name SchName Startdate Endate 1 Jim Sch1 01/09/2010 20/10/2010 1 Jim Sch2 01/11/2010 1 Jim Sch3 09/10/2011 2 Kim Sch1...

Dear all, I am trying to automate appending data from several spreadsheets and importing the data into a table. The issue I have is, how to make an append query so that if a column name on the imported spreadsheet is missing, how to automatically amend the access append query on each column...

Hi all, I have the following query:: UPDATE [dbo_vwAttendance Live] INNER JOIN offRolll ON ([dbo_vwAttendance Live].PER_DOB = offRoll.DoB) AND ([dbo_vwAttendance Live].PER_SNAME = offRolll .Surname) AND ([dbo_vwAttendance Live].PUP_UPN_DFEE = offRolll.UPN) SET [dbo_vwAttendance...