Search results

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 🤔🙃

I don't think the fact that the form you want to open has subforms is a problem. The way you open it is more likely a problem. Where did you place the button to open the second form? If it is on the first mainform, your code won't work. On the subform there can be multiple CustomerIDs so...

I do not understand how to use cascading combo boxes when only one field is involved.

The first 5 positions do not represent anything. Examples: ProcuctCode BE_0010027/1 BE_0010027/100 BE_0010032 BE_0010034/1 BE_00100424/1 BE_00100424/100 BE_00100444 BE_00100644/1 BE_00100644/100 BE_00100644/50 BE_00100644/500 BE_00100654/1 BE_00100664/1...