Search results

From what I see Colin recommends I use labels that gets hidden when record counts return 1?? But I Have txt boxes control, wouldn't that conflict with other data or slow performance? Is there a better way that the same thing can be achieved from within a query?

Sorry I don't think I'm using the right terminology, so here's a visual. Parrent TABLE ID DATE STATUS 1 1/1/18 Pending 2 1/2/18 Pending CHILD TABLE ID P_ID Warning 2 1 L5: Fuel Alaram 3 1 L6: Fuel Alarm 4 1 L7: Fuel Alarm 5 2 L5: Fuel Alarm...

That is exactly what I have. The data is being pulled from a query, that is why I was asking if it can be done from there instead of the form?

Thank you for the quick response, but I don't think that will give me the desired result. What I'm trying to achieve is summary information on one line per parent record that can be clicked open to show all the information. Is there a method for setting this up in a query? Kinda like an email...

Hello Community, I have two tables (let's call Parrent & Child ) The parent contains information such as date and status of alarms, the child contains information that relates to that record via a relationship such as alarms that occurred that date. What I am trying to accomplish is a form...

Thank you all for your quick response! I am a novice and have never needed to use such functions as max, frankly speaking, I wouldn't even know where to place the snippet of code or how to write it. I'm sure there are tutorials out there that show you how to accomplish this, but I have two...

Hello, I'm working on ms access database to track fuel tank inventories for a multi-store operation. Typically on a pen & paper, you would have the following column headings. Which is what I replicated on access. I can't seem to figure out how to code the opening balance to give me the desired...