I have this table called Facturació:

I have a table with grocery items, brands, and expiration dates:

I have two tables: The first is a table of roles where each person is in a team but person c has changed teams in June:

I am trying to create a basis for a list of products in an MS Access Query. The basis must later be used in a form where the products are visualized with only one of the many images associated with each product.
The image name is calculated with an expression field based on the product ID and color ID, which is also the composite primary key for the table.

I’m trying to find the first SeqGrp and SeqNum of the first unique values TaxGroupCode. I had this query in a MSACCESS query (Shown below), but we recently started using SQL 2008 instead. However, it seems “FIRST” isn’t a valid function in SQL (at least in this version).

In MS Access, I have a query summing a quantities from one table, a union query summing hours from three different tables, and finally a third query joining these two queries through alike part numbers and part descriptions. When I do this, the summed hours for some of the part numbers comes back as null.

I tried to use

I have a Microsoft Access database which has quite a few fields. For the purposes of this report that I am generating, I need to essentially create a list of names. There are some names that are in the database multiple times for different reasons. I need my report to only list each name one time. If I set the hide duplicates on Last Name only, it could eliminate some entries that I want shown, as multiple people can have the same last name. Same issue if I hide duplicates on First Name only. If I set the flag on both fields it compounds the issue. How do I form the query to de-duplicate the data based on Last Name & First Name?

I have a table (2016 New) like that with some duplicates

I have a table (2016 New) like that with some duplicates