Recent content by shopoholic

Ok, thanks I will try that. Not too hot on macros though so might be back for help on that! :o

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

Hmm.... Tried your code but it returned a message saying "you tried to execute a query that does not include the specified expression 'Left$([Field8], Len([Field8])-3)' as part of an aggregate funtion. What does this mean?

good point - thank you! Just one more (perhaps dumb) question: where do I put that in my query? I have tried looking on the Help files on Access and although they both contain info about the Left and Len funtions, they do not indicate where to use them. I have tried this (please don't laugh...

thanks for the advice, but unfortunately there is no space in the postcode field, its just one string of characters. Any other ideas? :o

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

Thanks! Thanks again Pat, its working now and interestingly highlighted a problem with people entering dates incorrectly, so has been useful in two ways! :)

Thank you for your suggestion. I tried it but the only problem is that when I run it, it asks me for the arrival day - any idea why it's doing that???

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

Sorry not to reply sooner, I've been away. Thanks for the help Pat, I've got it working now. :) :) :)

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

thank you! Thanks Neil and Peter both of your queries worked have have given me the start I need. Thanks so much! :)

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