Search results for query: *

the rowsource of a graphiclooks like this: SELECT (Format([Schadedatum],"MMM 'YY")),Sum([AantalVanSchadenummer]) AS [SomVanAantalVanSchadenummer] FROM [QryOverzichtJaar] GROUP BY (Year([Schadedatum])*12 + Month([Schadedatum])-1),(Format([Schadedatum],"MMM 'YY")) (this...

I wrote the following function in 97: ------------------------------------------------------------ Dim db As database Dim rst As Recordset Dim query As String Let query = "SELECT * FROM EXPORT2 WHERE chauffeur = " & Me.KzeI.Column(0) & " and Naam = " & Me.KzeI.Column(1)...

I'm wondering how I can base a query on (the rowsource of) a list of values. I have a list of values and then I want a query with the argument that one field of the query is based upon the values that are also in the list of values and then proceed with the query to do other things. I hope...

I'm wondering if I can base a query upon the rowsource of a list of values. I have a list of values and then I want a query with the argument that one field of the query is based upon the values that are also in the list of values and then proceed with the query to do other things. I hope you...

Is there some sort of syntaxis for? I can't find it.

I have 3 lists of values, containing day, month and year. There are 3 possiblities: choose day and month and year, choose month and year or choose nothing. How do I search in a table for the records? I put them in "Keuzelijst" I've got this, but it doesn't work properly: If...

I wrote some procedures which are like the following: If KzeDag.Value = Null Then dag = "**" Else: dag = KzeDag.Value Stop End If If the procedure has stopped, it says KzeDag.value = Null, but he doesn't proceed with the action dag = "**", instead he jumps to the...