Search results

I have a database with two tables. One for rental car bookings, and one for rental car returns. Tables are structured as below: Bookings Table: ID Location Booking Date Quantity Returns Table: ID Location Return Date Quantity I am basically trying to make an inventory calculation. I have made...

Hi, What is the easiest way to create a query to generate a drop down list with dates organised into months? I have tried to do a distinct query then group by, but it turns out this isnt allowed.... I tried: SELECT DISTINCT Format([cDate],"mmmm yyyy") FROM AuditTbl ORDER BY...

I have a table which has the following information: Name Team Date Score (as a decimal/%) Is it possible to have a query which would look similar to this, where each % is the average for that team during that month: Team September 13 October 13 November 13 Team A...

I am trying to use the wildcard in a query and failing miserably. I have two combo boxes on a form. One contains the months, and the other the department. I want to make it so that you select the month from the combo box, and if the second combo box is left blank, all records(for that month)...

This is driving me crazy. I am creating a database for call quality monitoring. Just when I thought everything was working perfectly, I get an error saying the record set can't be updated. I can't find anything useful about it online either. here is my database: I have a table which is...

Hi! I know you're not meant to do this, but I can't think of any other way. .. I have a score marking template for an internal audit. A criteria is either met, or it is not. All of these questions have Yes/No data type. each question has a weighting. I have written a VBA function to work out...