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

Perfect. Thanks.

Thanks. I tried that, but it seems to be ordered alphabetically rather than in order of month?

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

hmm for some reason my formatting didnt work out. Hope it is still understandable...

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 tried =iif(forms!reportfrm!combo2 is null,like "*",forms!reportfrm!combo2). Is this different?

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

It is based on a query. How do I tell if the query is read only?

That is essentially what I did, but as part of an on click macro. So, click the numeric primary key, and the on click macro executes the docmd.openform and uses the primary key as the Where Condition. This all works and the correct form is opened to the correct record. It just can't be updated...

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

How do I create an unbound control on a form?

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