Search results

Hi there, is it possible to select all datasets in a Combo box? That I don't have to select every single dataset.

EDIT: Guys I found a way. Thank you guys!

Okay I don't get it to work. Is there any other possibility to get just the ID with the MaxEventdate that I've choosen? Now my query selects the ID and the MaxEventDate. I want to create a Dropdown where i can choose the ID to get all MaxEventDates for that ID. Maybe someone know other...

like that: SELECT tbl_Mitarbeiter.ID, tbl_Mitarbeiter.Nachname, tbl_Mitarbeiter.Vorname, tbl_MitSchul.eDatum, tbl_Schulungstyp.SchulName FROM tbl_Schulungstyp INNER JOIN (tbl_Mitarbeiter INNER JOIN tbl_MitSchul ON tbl_Mitarbeiter.ID = tbl_MitSchul.Mit_ID) ON tbl_Schulungstyp.SchulungsID =...

Hi there, I've build a form where I can pick an Identity number in the Dropdown menu to get all events of that person. It works perfect, but I've realized that it shows really every event. Every Event is categorized. My Problem is that is just want the latest event for each category for that...

It works perfect! Thank you for your fast answer! Georg

HI guys, I want a query where I can see the product and the latest date. Is this possible? Can someone help ? Best regards Georg

Good morning, I've 3 tables (tbl_Medical, tbl_Employee & reference table tbl_EmpMed). fMedical in tbl_Medical is the standard frequency of each medical examination but they can be personalized if there is a need. Frequency in tbl_Emplyee is the personalized frequency for each Employee. My goal...

Hi guys, I couldn't find something like what I'm searching. I think it's not possible. The searching Option is working but I can't edit the results. So it isn't useful for me. Best regards Georg

Hello again, I want to build a form that is like a query but I can edit the queried data sets. Should be like: type in the ID of the product you want to edit. Shows me every product with the ID and I can edit the price of the product. Any ideads? Best regards Georg

Thank you all guys!

Hi there, I've 3 tables (tbl_all, tbl_students, and tbl_tests) I want a database to check if the students have done their Tests. The amount in tbl_students shows how often the students have to do their Tests per year. So my Goal is to create a form where I can select the Student and the test...

The Problem is that the Chart labels change. Thanks June

Hi there, does someone know if it's possible to link the circled(dia.jpg) with other Charts. So if I click on the circled Name a new Chart opens. Maybe someone of you got an idea.

It worked Pretty well! Thank you CJ_London Have a good one

Hi there, I have a problem with my Chart. Sometimes the value is to big and my line goes out of the Chart. Does somebody know how to cut my value if ist bigger than 1,5? So if it's 1,6 it will be cut to 1,5. In Excel it's (X1 > 1,5;1,5;X1) Best regards Georg

Thank you I've done it now with SELECT tbl_Kennzahlen.KennzahlName, tbl_all.kz_ID, Sum(tbl_all.Wert) AS WertALL, Sum(tbl_all.Soll) AS SollALL, tbl_all.Ziel FROM tbl_Kennzahlen INNER JOIN tbl_all ON tbl_Kennzahlen.ID = tbl_all.kz_ID WHERE (((tbl_all.grp_ID)=1) AND ((tbl_all.ab_ID)=1)) GROUP BY...

Sorry for the waiting time i've been ill. c3.jpg is the relation of tbl_all and tbl_kz. My Goal is that the red circled gets me the Name due tbl_kz and that the blue circled is summed. It should be like this tbl_kz tbl_all KennzahlName...

Hi there, I got a query that sums all set values and actual values of every Business ratio. But I can't select the names of my Business ratios. Maybe someone got an idea how to get both ? Everytime I want to select the name I get a warning that my aggregation function won't work with the name...

It worked! Thank you, I appreciate it a lot!:)