Search results

Thank you guys for all your help.

The problem with that is this excel document will be getting more data added to it and I won't be able to constantly update the queries.

I've uploaded the test excel to show what the data will look like.

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...

Thank you I will look into changing it.

Thank you everyone i figured it out. It was as simple as using distinctrow. I dont know why I didnt think of it before.

Thank you, I'm glad to be working with databases. The ssn is just used as a unique way to describe each employee and it does not show up on any report. No one but Hr personnel sees beneath the reports. But I will mention it to my employer to see if it should be changed. The families are for the...

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...

I've just started the statement there are many other families and each employee has more than one family they are qualified in. So I need to bring each employees family together in one query to create a report. I figured I could group on social, but it is still giving me the same employee...

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...