Search results

Assuming Table1 and table2 are already created and you don't mind executing 3 queries the following will work: INSERT INTO Table2 ( RecordID, MD ) SELECT Table1.GROUPING, First(Table1.Info) AS FirstOfInfo FROM Table1 GROUP BY Table1.GROUPING; UPDATE Table2 INNER JOIN Table1 ON...

What does your Query look like?

What don't you understand?

If T3 was you table name and item is you item name containing your text records you could use the following query: SELECT t3.Item FROM t3 WHERE (t3.Item Like "@*@12");

What are you using to to the search and replace? A query, code?

I shortened your table names to a1, and t1 just to save typing but try the following: SELECT a1.adres, a1.prefix, t1.status FROM a1 INNER JOIN t1 ON a1.adres=t1.adres WHERE [status] = (SELECT Max(Status) FROM t1 Where (t1.adres=a1.adres) GROUP BY t1.adres;) Lou ...

Try: SELECT top 4 Year FROM YearTable GROUP BY Year ORDER BY Year DESC;

Given Article, the following function would compute Average cost: Function GetAverageCost(Article As String) As Currency Dim dB As Database, Rs As Recordset Set dB = CurrentDb() Set Rs = dB.OpenRecordset("SELECT sArticle, Avg(Supplies.sPrice) AS AvgOfsPrice FROM Supplies " _...

From the last Info you gave me I made the following tables with the data you supplied: Invoices iNumber iDate iArticle iQuanity iWholeSalePrice iCostPrice 101 4/1/2004 a55 15 $3.41 $0.00 102 7/1/2004 b64 7 $7.66 $0.00 103 10/1/2004 c564 56 $9.52...

Assume sTable Cantained data simular to: Siteiid Musym 450 38E 450 38E 450 38E 450 38E 450 38E 451 38E 451 38E 451 38E 451 38E 451 38E 452 38E 452 38E 452 38E 604 38E 604 38E 604 38E 604 38E 610 38E 610 38E 610...

Seems to me that the siteiid field is already you ranking. Are you just requiring that your ranking must start with one?

If Nlee is your problem why not just exclude it in the where clause? SELECT Results.TestId, Results.[No], Results.TestStatus, Results.TestTitle, Results.TestScreen, Results.Test_FileName FROM SerPTestInput INNER JOIN Results ON SerPTestInput.SerpTestInputId = Results.TestId WHERE...

Sorry I pushed post twice. Louie ...

It would help me to understand your problem and maybe provide better help, if you could show the table structures of both the Supply and Invoice tables with just a few data entries, not 500000. Also a Results table i.e. where do you want the results put? Also would it be ok if the solution...

Your Query could make Table_A as follows: SELECT Table_B.Code, Sum(Table_B.Amount) AS SumOfAmount INTO Table_A FROM Table_B GROUP BY Table_B.Code;

Is there a way to programmatically set a default search directory and default file type for the “File Search” available from the File menu in Microsoft access?