Search results for query: *

then it says: operator missing

yeah that was my first idea as well, but that doesn't work...

...'YY")),Sum([AantalVanSchadenummer]) AS [SomVanAantalVanSchadenummer] FROM [QryOverzichtJaar] GROUP BY (Year([Schadedatum])*12 + Month([Schadedatum])-1),(Format([Schadedatum],"MMM 'YY")) (this rowsource is from the wizard) I want to use this in VBA, but at the first &quot...

Ok thx so far

It indeed doesn't recognise the DAO.database. I downloaded DAO 3.6 and installed it, but don't really know how it works, because he still doesn't recognise the DAO.database...?

What kind of field do you want to put them in?

...------------------------------------------------------------ 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) Set db = CurrentDb() Set rst =...

Thx for the reply Dale. It is in Access and in the meantime I've progressed a little bit. I even called Microsoft, but they said it isn't possible (I almost got Bill on the line to ask why it couldn't be done). So it's in Access, I've got a list of values there with the possiblility to select...

OK leave the like part out of the criteria. that doesn't make sense

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...

what kind of field is it?

thx a bunch

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

yes thanks! brilliant idea!

No, that's not quite what I mean. I want him to search for everything containing 04-2002 when a user only filled in month and year. That's the tricky part...

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...

thx everybody. It works!!!!!!!!!!!!!1

no it still doesn't work. I solved it like this and it works now, but I still think the other way was good. could there be an error in vba? If KzeDag.Value <> &quot;&quot; Then dag = KzeDag.Value Else: dag = &quot;**&quot; End If

KzeDag is a list of values and it still doesn;t work with Empty :(