Search results

Hello I have created a database for my department to log all of our jobs to keep track of them and I want to create a simple search for them but I am having difficulties. I am familiar with creating queries to search tables for matching records, but is it possible to get search criteria from...

Hi everyone I need to run a query that returns the number of bookings made for each week so far this year. However the date is held in DD/MM/YY format. I had a similar query that worked fine for monthly grouping using Month([Start Date])AS FilterMonth but tried replacing month with week...

Am trying to query a customer database to find a how many instances of each postcode exist to determine geographic distribution. Only interested in the first part of the postcode so the following code was suggested: SELECT Count(owners.Field8) AS Total, Left$([Field8], Len([Field8])-3) AS Code...

Still need help with query on part of a postcode field Hello all! I have a customer database and I basically want to find out their geographical distribution. To do this I need to run a query that gives me the sum of customers for each postcode, but this is dependent on only the first few...

Still need help calculating difference between dates Hi there I need to perform a query that works out how far in advance people book holidays. I have the arrival date and also the booking date, and I think I should be using DateDiff. However, I tried to put it in an existing query and it...

Hello all I had a query which was working fine to tell me the number of weekend bookings for holiday parks for a specified year: SELECT Bookinfx.[Park Name], Month([Start Date]) AS FilterMonth, Year([Start Date]) AS FilterYear, Count(Bookinfx.[Park Name]) AS Bookings FROM Bookinfx GROUP BY...

I need help to design a query that is more efficient than the method I am currenlty using. I have a database containing information about bookings on holiday parks and I had devised the following query: SELECT Bookinfx.Key, Bookinfx.[Park Name], Bookinfx.[Start Date], Bookinfx.[Start Date]...

I am having an annoying problem that I can't understand. I have the following query: SELECT Bookinfx.Key, Bookinfx.[Park Name], Bookinfx.[Start Date], Bookinfx.[Accom Type] FROM Bookinfx WHERE (((Bookinfx.[Park Name])="TORBAY") AND ((Bookinfx.[Start Date])>=#01/01/2005#) AND ((Bookinfx.[Start...