Hi All,
Please Solve this problem,
Let me give you the problem -- I have two tables one called Main and the other is called Donations and there are two fields in Donations table one is date and another is notes.ID is a field in Main table which is a primary key in Main and foreign key in Donations.
 What we have to do is that -- we have to arrange and display the Main table records in such a manner so that the Ids who have a "Desired Match" against their notes field in the Donations table and minimum date in the date field comes first on ascending order of date arrangement.
Thats all
Can you sort it out without using any (min),(Distinct) etc key word.

ps_kaushik

Hi,

   Here is how I would do this assuming this is the proper table structure:

tblMain
notes.ID - PK (bad name since PK should be table name + ID, Pascal cased, no periods.
...

tblDonations
DonationsID - PK
Date - (bad name for this field as its a reserved name)
notes.ID - FK tblMain


   Open the query builder in design view.

   Add tblMain and tblDonation to the design window.

   Select the requisite fields from each table that you want.

   Sort the Date Ascending

   If you want to get some criteria from the user during the query runtime, then enter this on the criteria line:
   Like "*" & [Enter Desired Match data:] & "*"
   This will allow you to look for a match in the middle of the string. If it will always be at the beginning or end, then remove the other asterisk accordingly.


   If you want to pass the Desired Match data from a combo box on a form, then I can show you how to do that.

HTH




mmcdonal