Recent content by fransanchezoria

Hi, I'm trying to group different records with the same key value. Let me show you an example: ID / Person ID / Title 1 / 1 / Title 1 2 / 1 / Title 2 3 / 1 / Title 3 4 / 2 / Title 4 5 / 2 / Title 5 I want...

Hi, I have a Datediff field that calculates the diffrence in months between two dates. Now depending in this value, I want to assign a number. For example, if the range for difference in months is (stored in a table): Diff Value <12 1 12-36 2 >36 3 I would like to build a query...

Hi, Sorry for the somewhat confusing question. I want to generate emails from Access and auto manage replies. But I need to include data from the database in the body of the message. Say for example that for one record I have: Name: John Surname: Smith Purchase: Candies Confirmation: (this is...

Thanks for your answer Galaxiom. I think I know what you mean, but I'm quite a newbie writing stuff in SQL, could you give me an example of how to join two subqueries? Thanks again beforehand!

Hi, As the title says, I need to do a count for distinct values in two columns. For example: IPC Family ID Another ID A01C 40059407 4764 A01C 41665653 399 A01C 41665653 1941 A01D 34009322 8415 A01D 34035545 8533 A01D 34035545 8530 A01D 34035545...

Thanks MStef, I ended up following your advice. I knew I could create another table but I was hoping I didn't have to do this because I like to keep the data uncluttered. Thanks for your advice the template worked like a charm!

Hi! I have a problem that I am sure it's easy to fix but I am too much of a newbie... In my data, I have records with Family IDs, inside these families there are usually one to 10 records but I am trying to analyze my data based on Family IDs. I created a query and selected a few fields...