Search results

Nice job. Happy to see you getting the answer. Can you please the SQL with Syntax ? I will copy and paste to see if it works for me. Rgds.

SELECT [Offered Products and their Specifications].Product, [Offered Products and their Specifications].Specification FROM [Needed Product Specifications] INNER JOIN [Offered Products and their Specifications] ON [Needed Product Specifications].Specification=[Offered Products and their...

Did not help, my friend.

I can swap the tables. In that case left table will have two names and the right table will have 12. I need 10 names. Then what will be the Syntax ?

This is a real world problem for me. I suspect my Syntax. I have not used any Primary Key.

In Maths, we have Union and Intersection. This is the case of Intersection.

SELECT [Table1].Flower FROM [Table1] LEFT JOIN [Table2] ON [Table1].[Flower] = [Table2].[Flower] WHERE ((([Table2].Flower Is Null));

Thanks, Plog. The result I got is a blank table, whereas I should have got 10 names of flowers.

In Table 1, I have a list of 12 flower names. In Table 2, I have a list of 2 flower names. I want a list that contains 10 flower names (12-2). Possible in MS Access ?

In one table, I have a list of specifications I am interested in. The format is as under: Table Name: "Needed Product Specifications" Column Heading: Specification Under this heading there are 2 (can be more) specifications which I have listed, which I am interested in. There is a second...

Is it possible to send you a direct message by Email ? Thanks.

I typed properly but it is appearing the way it does once the query is posted. Thanks for your interest. In one table, I have a list of products which meet various specifications. Some of these specifications are common between products. I have a set of specifications and I want to identify...

I have table (a) that contains the following info: ProductCostSpecnProduct A100MProduct A100NProduct A100OProduct A100PProduct B125NProduct B125PProduct B125QProduct B125RProduct C150MProduct C150OProduct C150P I have another table that indicates the specifications I am looking for in a...

Thanks, Thomas. It has worked. But now I have different type of problem and I need your help again. I have a query in which marks attained by various students are given in the following format: Student Name Exam1 Exam2 Exam 3 1 2 3 4, etc.. I need to add the marks for each...

(1) I have a table of 11 cricket players - A, B, C, D, E, F, G, H, I, J, K. (2) I have a query that indicates batting strengths of 10 of them. The strength of 11th player, K, is not there because it is 0. (3) I have bowling strengths of 4 of them in a different query (say D,E,F,G). The bowling...