Search results

Hi, I have a combobox, and when it's form opens, it is set to null. If the user selects a value from the combobox, perhaps in error, I can't figure out how to allow the value to be deleted. Each time the value is deleted, and the user tries to set focus to the next control, they are presented...

Doing that resolved my issue. Thank you for your help.

Here's what I'm using SELECT tblQuotes.QuoteID, tblQuotes.Supply_ID, tblSupplies.Supply_Num FROM tblSupplies INNER JOIN tblQuotes ON tblSupplies.SupplyID = tblQuotes.Supply_ID; I changed the names in my original post, apologies. When I run the SQL, the Supply_Num displays, but I can't get it...

Hi, I have 2 table setup like :- tbl1 SuppID FirstName Etc Etc tbl2 Supp_ID SuppNum Etc Etc The table are related by SuppID<->Supp_ID I have a form where I want the user to find a record based on a combobox selection. Currently this works by selecting a SuppID from tbl1 as displayed in the...

Worked perfectly - thanks.

I have a main form (frmMain) and a sub form (frmChild), set as datasheet. The first field in the datasheet is set as a hyperlink and opens another form correctly. What I would like is if the user selects a record on frmChild, then a textbox on frmMain is populated by the corresponding value in...

I went with MAX, and added some extra checking for null values. Thanks a lot for your help, and the useful website. Solved :)

Yes, you're right, there were multiple records. Also, I didn't have the query set as a Totals query. Is there a quick way to force a result of just one result per InvNo? It is not necessary to do any checking on the result brought through.

Hi, Based on the link you sent, I created 2 queries :- SELECT tblInvoice.InvNo, Max(tblInvoice.EndDate) AS MaxOfEndDate FROM tblInvoice GROUP BY tblInvoice.InvNo; and SELECT tblInvoice.InvNo, tblInvoice.EndType FROM tblInvoice INNER JOIN qryRTypePart1 ON (tblInvoice.Enddate =...

Hi, I have a query returning 3 fields :- Num - MaxEndDate - EndType 0001 - 01/03/12 - E 0001 - 23/02/12 - N etc etc How can I change my SQL below to ensure that only the the record with the highest date is returned per "Num" SELECT tblInvoice.InvNo, Max(tblInvoice.EndDate) AS...

Hi, I'm using the SQL below in Access 2010 :- SELECT tblMerged.Col4, (select sum(dupe.col8) from tblMerged as dupe where dupe.col4 = tblMerged.col4 and dupe.col2 = "I" group by col8) AS Expr1, (select sum(dupe.col12) from tblMerged as dupe where dupe.col4 = tblMerged.col4 and dupe.col2 =...