Search results

Hi.. A query in this structure, gives the desired result.. table_name instead, type the name of your table.. select MonthOpen, OpenTotal, ClosedTotal, ( select sum(OpenTotal-ClosedTotal) from ( select...

Hi.. Try this way..: SELECT format([The Date],"mm\/yyyy"), [Aeration Data].[30 Minute Settling Test], [Aeration Data].[MLSS (mg/L)], [Aeration Data].[MLVSS (mg/L)], [Aeration Data].[Ammonia In (mg/L)], [Aeration Data].[Ammonia Out (mg/L)], [Aeration Data].[Ortho-Phosphorus In (mg/L)]...

Hi.. This sample application. in the combobox, without making a selection, provides filtering of the listbox with the cursor. a different approach to filtering with the listbox.. Give an idea.. ;)

Hi.. For all the fields to check..: select * from table1 where srcode & vilcode & sncode & sdcode not in ( select (srcode & vilcode & sncode & sdcode) from table2) Or..: select * from table1 as a where not exists ( select 1 from table2 as b where...

Hi.. Button and the value, looks in the same form.. Direct call without specifying the form name. Msgbox me.drawingno

Hi.. Try to define a variable criteria..: Dim rCnt As Integer Dim trz as string trz =Me.Community rCnt = DCount("[CommunityID]", "InputTable", "[CommunityID]= '" & trz & "' ") If the value of a number of criteria..: Dim rCnt As Integer,trz as integer trz=Me.Community rCnt =...

Hi.. I prepared a query for you .. I hope that gives the desired result..: select PurchaseActions.PurchaseID, PurchaserName, ProductID, PurchaseStage from ( ( select PurchaseActions.PurchaseID, max(PurchaseActionDate) as last_date...

Hi @jackadamson.. The query looks correct. :confused: Can you add a simple example db..

My English is not very good. I do not want to mislead .. As far as I understand it..: If you use this criterion in the query, sql view, try to change semicolons commas..

Hi.. Try this way criteria. Between dateserial(year(date())-1;month(date());1) and dateSerial(year(date());month(date());0)

Hi Jakob.. My fault .. ;) I updated my message above .. Please try again..

I think I understand now.. ;) select format([date_field],"mmm") as tmmm, ( select sum(value_field) from ( select date_field, value_field, month([date_field]) as tmonth from table_name as trz...

Hi.. This query gives the monthly totals.: select format(date_field,"mmm"), sum(value_field) from table_name group by format([date],"mmm")

Hi.. Would you try this way..: Private Sub Form_Load() call combobox_name_Afterupdate End Sub I hope you do not understand the wrong question.. ;)

Hi.. I guess this is not possible .. But the alternative available to prepare the check box ..: Translation can be bad .. If necessary, i add an example..

Hi.. Can use this command.. Docmd.gotorecord ,"parent_form_name", acnewrec

Hello.. Changing file path for linked tables, an application that will help you..

Hi.. "Topcode" grouped field. error should not be. Did you use the bottom row of group? Is an alternative to this query but than before, is a long way.. select topcode, ( select min([date]) from ( select table1.TopCode, table2.[Date] from...

Hi.. If you want to find the date that the smallest of topcod, try this.. select table1.TopCode, min(table2.[Date]) as min_date from table2 inner join table1 on table2.SubCode = table1.SubCode group by table1.TopCode

Hi.. You can also use this as an alternative way. Me.cmdViewReport.Enabled = Not (IsNull(Me.txtDateStart.Value) Or IsNull(Me.txtDateEnd.Value))