Search results

Try this..: switch([A]=1,"Help",[A]=2,"Stop",[A]=3,"More")

Hi.. Try this.. select field_name from table_name where nz(field_name,"")=IIf([Forms]![Form1]![Date] Is Null,nz(field_name,""),[Forms]![Form1]![Date])

you are welcome.. ;) okay .. I add a picture related..:

Hi.. Try changing the query in this way.. QrySearchRASKRSNICA SELECT DISTINCTROW RASKRSNICA.IME_RASKRSNICE, UREDJAJ.TIP, TEREN.TEREN, RASKRSNICA.DETALJI FROM UREDJAJ RIGHT JOIN (TEREN INNER JOIN RASKRSNICA ON TEREN.ID_TEREN = RASKRSNICA.ID_TEREN) ON UREDJAJ.ID_UREDJAJA =...

I think so.. If you examine the subquery, you might think the same thing.. at least in my experience, I said it.. ;)

hi scubadiver007.. ;) when examine the structure of the query, i do not think would be an alternative is other methods.. use of the temporary table is the best way i think in this case.. see the attachment..:

hi.. as though this more accurate.. Sum(IIf([Days Aging]>=21 and [Days Aging]<46,1,0))

Hi. I assume that the ID field in your table..: select Customer ,Site ,OrderDate ,OrderCategory ,[OrderCat-2] from ( select OrderCategory as [OrderCat-2]...

Hi.. refresh 'try adding it.. Dim rs_nb Set rs_nb = CurrentDb.OpenRecordset("SELECT count(Num_Mdat) as nb FROM tbl_mandats WHERE b_chk = -1;") If rs_..... ........... ................... ............................

Hi..: You can sort with code.. on open is report event..: orderby= "year([date]),month([date])" or try same structure in query..: PARAMETERS [Forms]![frmReport]![startdate] DateTime, [Forms]![frmReport]![enddate] DateTime; TRANSFORM Nz(Count(qryEpisode.EpisodeID),0) AS CountOfID SELECT...

Hi.. Try this way..: [Forms]![frmSwitchBoard]![frmClaimSearch].[Form]![Text54] opps... ;) I saw now Mr. B..

Hi.. ;) Put this function in a module..: 'Author: Allen Browne. http://allenbrowne.com. June 2006. Function ParseWord(varPhrase As Variant, ByVal iWordNum As Integer, Optional strDelimiter As String = " - ", _ Optional bRemoveLeadingDelimiters As Boolean, Optional...

Hi..: Try this way..: Dim Rs As Recordset Set Rs = Form.Recordset If Not Rs.EOF And Not Rs.BOF Then Do Until Rs.EOF If chbox_rec = True Then tb_test = "Checked!" End If Rs.MoveNext Loop End If

Hi .. Put a module in this function ..: Public Function ConcatRelated(strField As String, _ strTable As String, _ Optional strWhere As String, _ Optional strOrderBy As String, _ Optional strSeparator = " | ") As Variant On Error GoTo Err_Handler Dim rs As DAO.Recordset...

Customer's field text data type, try this..: =DLookUp("[Hourly Billing Rate]","Tbl_Customers","Customer='" & [Customer] & "' ")

=DLookUp("[Hourly Billing Rate]"," Tbl_Customers","Customer=" & [Customer]) Hi.. Try this way..

Hi..: table_name = name of your table should be.. please try to..: select customer, Site, (select last(orderdate) from table_name where customer=trz.customer and ordercategory=trz.orcategory) as ordate, orcategory from ( select...

Hi.. a part of your question about, there was a my file. i add.. colors you choose are applied to all forms..

Hi.. ;) Properties / format / format = dd mmm yyyy

Hi.. ;) This function allows you want..: Public Function trz(scr) As String Select Case scr Case 90 To 100 trz = "Excellent" Case 80 To 89 trz = "Good" Case 60 To 79 trz = "Accepted" Case Is < 60 trz = "Failed" End Select End Function I used this function in...