Search results

So what I have is an excel document the lists all the purchased product. I have this excel document linked to an access table and would like to break it down from there to see the data by months. It doesn't matter if it breaks it down into tables or queries. Invoice DateInvoice QtyItem...

So I'm trying to group the employees and have which families they are qualified under. The query the data is coming from each employee is in there multiple times for each family they are qualified for. I want to bring that data together and only have one row per employee. The SQL I have written...

Every time I run this query access tells me Iff statement isn't part of aggregate function not sure what to do? SELECT Employees.[SS #], Employees.Status, Employees.[Senior Date], Employees.[Last Name]+", "+Employees.[First Name]+" "+Employees.[Middle Name] AS Employee, iif ([Employee...