Search results

Great bastanu, This was exactly what I was looking for, I did came across that 'union queary' but didn't see it fit to use, I also tried crosstab with my tab but to no good, this is exactly what I needed many thanks. by the way where do you write this code to make that query a 'union query'...

well, lets put it this way In Belgium we have a lottery, i'm trying to make a statistic of it (my dad did this before succesfully by hand). now what i'm trying to do is the following: i have a database of each draw of 7 numbers (random numbers from 1-45) on weekly bases now i want those numbers...

I got a table of 7 numbers (between 1-45) on a certain datel. Now I want to get them in to a query with a date row and row numbers from 1-45 now would like to mark those numbers picked on a certain date marked with an X. I tried this with IIF but can't get it. I managed to make a query where the...

Finally got it the flaw was in the ' , ' behind [Datum] should be ' ; ' instead FIELD: Weekday([Datum];1) CRITERIA: 4 Thanks for the help!!! been searching for days!!!

When i try to save this I get following error (ruffly translated: the syntaxis of this expression you specified is invalid

this is what I have now but get an error when activating it, it's in dutch... so sorry about that

I do understand the numbering of the days in the week but I don't know what to add in that datefield.... just want all the dates filtered out. Next is in that tutorial-link above they set an Expr1: Weekday(#12/03/2001#,1) in the field name? I can only choose between my fields that are in my...

Got a problem, I got a large database imported from excel with only days on saturday and wednesday. I made it in a long date notation in the hope i could filter it on wednesday or saturday, to no succes. I just want to get 2 seperate queries where i have one where only the wedsnesdays are shown...

Hi all, i'm from Belgium. Dn't have much experiance with access but eager to learn. So thanks to listen to my (stupid) questions...;)