Search results

Okay, I tried to attach what the samples would look like

Lol, that doesn't look like it was supposed to

You mean like this? Starting sample: Discharging ProviderLevel of CareTypeTrending DateTotal%Provider C3LA02/01/20151312%Provider A3NA01/01/2015820%Provider B2LA02/01/2015823%Provider C1NA11/01/20141050%Provider C1NA12/01/2014565%Provider B2LA01/01/2015568%Provider A2NA10/01/20146100%Provider...

Okay, I pull the data from Aftercare Report data and the field names are Discharging Provider, Level of Care, Type, Trending Date, Total, % One provider may have 3 levels of care and 2 types but I need to know which providers are in the database 3+ recent months consecutively with the same...

Okay, I changed some of the Field Names SELECT [Aftercare Report data].[Discharging Provider Name] AS [Discharging Provider], [Aftercare Report data].[Level of Care], [Aftercare Report data].[Type], Format([MM/YYYY],"mm/dd/yyyy") AS [Trending Date], [Aftercare Report data].[Total Late or No...

SELECT Format([MM/YYYY],"dd/mm/yyyy") AS [Date], [Aftercare Report data].[Discharging Provider Name], [Aftercare Report data].[Level of Care], [Aftercare Report data].[Type], [Aftercare Report data].[Total Late or No Appointment], [Aftercare Report data].[% of Late or No Aftercare Appointment]...

Hi, I have a table in Access called Aftercare Report Data and the headers are as follows: ID, MM/YYYY, Discharging Provider Name, Level of Care, Type, Total Late or No Appointment, and % of Late or No Aftercare Appointment. I want to run a query that only shows Discharging Providers, who are in...