Recent content by Steffe1611

Hi I have a problem in converting the content of a simple table to a test format I need for an other program. The table is containing 3 columns - ITEMID - COLOR - MINQTY How do I convert the table to a text format with below format.? ITEMTYPE is all ways >P< How is this text...

Thanks Geotch It works fine, but I have a little question. How can this happen.? There were the space.? All the data comes from the same table, just filtered in different queries and then put into the query you just solved. I hope to learn a little. Thanks. Steffen

Hi. I have run into a little problem I don´t understand. I will compare two lists, but I don´t get the expected result. I have two tables: 1. with 39 lines 2. with 7xx lines I just want to find the matching "Lego part" in the two tables. There is a match, but the data base says something...

Hi Thanks to Drunkenneo By adding in a reference for the part and one for colour Q1 and Q2 works perfectly and by the right joint I got the Q3 Perfect thanks.

Hi Mihail I will try to explain in your format T_Set_1 <-> Q_Part_S Q1: LegoPart = LegoPart Farve = Farve Antal >= Antal Answer : 16 Q2: LegoPart = LegoPart Farve = Farve Antal < Antal Answer: 5 Q3 LegoPart + Farve Not = LegoPart + Farve (not match for part and Colour) or T_Set_1 - Q1...

Hi. The blank line just need to be deleted. Thanks for spending your time. Steffen

Hi I have attached the two files (in several formats) I don't think it makes sense looking at my old query as you properly have a smarter way to compare this. I have: 1. Query (attached as file) - 622 Records 1. Tables (attached as file) - 111 Records With the following criteria's: 1. Part...

Hi. I have attached the two lists.(in several formats, hope one of them fits you) I expect the query to return. 1. Equal match and pcs = 16 2. Equal match = 5 3. No match = (111-16-5) Once again thank you for your help. Steffen

Now with attachments:)

Hi. I have tried the distinct part but I can´t get to work Maybe I am on a wrong track but I will try to explain form the start. I have: 1. Query (attached as file) - 622 Records 1. Tables (attached as file) - 111 Records With the following criteria's: 1. Part 2. Colour 3. pcs. Wanted...

Hi. Maybe a simple question, but is confusing me a lot. I compare two lists and the query returns the below list The query returns the correct search in the Left part of the list but it makes a double line en the other side (marked with RED) SQL code: SELECT [Set 7897-1].[Lego part]...

Compaire two lists (on 3 criteria's) Hi. I have run into some problems by comparing two lists. My project is to compare two lists and on the below listed criteria's and with the wanted results. Criteria's: 1. Part 2. Colour 3. pcs. Wanted results: 1. Equal match (same part, Colour and pcs...

Hi. I am Steffen and from in Denmark. I use Acces to have control on a hobby to register Lego Bricks I am new to acces but have tried several time to use Acces but have given up a few times. Now I try again but I need help.:confused: I will post a concrete Query issue. Best regards...