Search results

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

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