Search results

Alex, Thank you very much for your answer, the 'monthname' function works perfectly! One remark about the semi-colon: since I live in Belgium and use azerty keyboard, it is mandatory throughout all Office functions to use semicolons instead of comma's, which do not work here :-/ Roger. To...

Hi! I have a select query with a date field in it, let's say a birthdate, and I want to show the field a second time, but then with the name of the month in full characters. So I made a calculated field in a new column: 'monthname: Month([birthdate])', and it shows the number of the month...

I have been thinking in that direction (see my original post), but it seems I cannot get it working. I'm trying to figure out how this working query: SELECT Max(HOTEL.NumberOfNights) AS MaxOfNumberOfNights FROM HOTEL; can be used as a criteria in a second query where I select name and roomtype...

Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, ... I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the...

Hi! My name is Roger, I live in Flanders (part of Belgium) and I am an ICT project leader. In this function it is sometimes necessary to do a little field work myself :p and I really enjoy developing something in Access. Mostly quite simple things, preferably without much VBA coding because...