There Must Be A Simpler Way Of Doing This?!

Jun 13, 2005

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]
FROM Bookinfx
WHERE (((Bookinfx.[Park Name])="COTSWOLD") AND ((Bookinfx.[Start Date])>=#1/1/2004# And (Bookinfx.[Start Date])<=#1/31/2004#));

Now this was fine, but I started getting asked to do several queries with different parks and different dates and changing these parameters manually in the code is beginning to become a pretty labourious task! :(

What I would really like (if its possible? :confused: ) is a query that gives me a count of the number of bookings for each park (there are 7 in total) for each month, e.g.

Park: COTSWOLD
Jan 123 bookings
Feb 338 bookings
etc
I know there is a Count function available to use, but I'm not sure how I could get it to do this. Also, I would like to add criteria, (for example where nights <3).

Any suggestions/help most gratefully received!

View Replies


ADVERTISEMENT

Convert CSV File Received From UPS To Simpler Table

Jan 29, 2013

I am trying to convert a CSV file that I receive from UPS to a simpler table. I have over 3000 entries from 25 different locations and I need to evaluate the shipping cost. Is there a way in Access to convert the file as attached or should I be trying to use Excel?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved