Recent content by AxeaXeaxE

then it says: operator missing

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

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

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?

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

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!