Search results

First of all I think the after update event will not work. You do not change the customer name, so the event won't fire. A requery of subform-2 will also only work If the recordsource of the form refers to the selected customer. Without knowing that recourdsource, I doubt this will be the case...

Thanks, that works.

I use the Dutch versions of Access and Windows. That means that the decimal separator is set to a comma by default. In a table I have a numeric field (single precision). Entering and displaying values works fine for this field. However, if I use the field as a condition in a function, I get an...

This is more or less a repost of https://www.helpmij.nl/forum/showthread.php/965998-Checkbox-true-op-basis-van-waarde-in-tabel The real problem is bad table design.

I don't think it is possible in the way you want. You could do the top part with a single cross-tab query. But that will only work as long as the number of products does not change. For the graphs you need separate queries. I made a demo for the top part with a cross-tab query. Maybe it is an...

I think your query should look like: SELECT ObjectType, DatePart("yyyy",dateInspection) & "/" & DatePart("q",dateInspection) AS Quarter, inspectionType, Count(object_id) AS NoOfInspections FROM tblObjects INNER JOIN tblInspections ON tblObjects.ID = tblInspections.object_id GROUP BY ObjectType...

I literally answered your original question. Afterwards I realized that it is actually not a good solution to make separate calculations for each customer. When a new customer joins, you have to adjust the form. It is better to create a continuous form based on a query that calculates the...

You need new calculations on the dashboard. See the attached database.

Another obvious solution is to copy the calculation from the other forms to the dashboard.

I have no Access at the moment, but I think the problem is that the other form is not opened.

BTW I also miss dates in the model. For example, about the validity of tickets and in the schedule (different drivers on a route on different dates?).

We do not know your business (rules), so it is hard to say anything about this. What strikes me is that tickets are linked to a certain bus and a certain driver. I would expect a passenger to buy a ticket to get from A to B. Your planning is something different I think. Also, it seems that A...

Good point 😡

Use the SPLIT function.

Make form to enter the dates. Also add a button to open the report. Both in your query as in your report you can refer to the controls on the form.

You are right. I missed MarkK's post. You are also (partly) right about breaking down in small steps. That is how I build this query. First make two query's and then integrate them. In order to maintain an overview, one query is ultimately better. If you don't know what you're doing, it doesn't...

Try SELECT * FROM Table1 INNER JOIN (SELECT Table1.Customer, Max(Table1.OrderDate) AS MaxOrderDate FROM Table1 GROUP BY Table1.Customer) AS Q1 ON (Table1.Customer = Q1.Customer) AND (Table1.OrderDate = Q1.MaxOrderDate);

It seems you are referring to a control on a subform (Forms]![frmCustomerOrders]![frmOrderItemSizesSubform]![txtCustomerID). That might be your problem. On a (continues?) subform there can be multiple such control. So which one are you refering to? Without further context (where and how is de...

As I explained you need to change the design. Then it is possible.

Thanks for all the reply's. I will do some research on "FAYT". I don't have any idea what it is yet 🤔🙃