I have a form that runs some functions and I want to be able to show unique values only for the form. Is this possible?
I have the form pulling its data from a query which I have unique values turned on. The query has report#, machine, component, PM, tech, datecompleted, and frequency. I have the form pull that data and compare datecompleted to today's date to tell me if it is overdue or not. All of that works great, but I only want it to show me the most recent PM performed per component per machine. In the query the unique value seems to only be the report number; it repeats machines and components and PMs. I'm not sure how to get it to do what I want.
I essentially want to have a list of every machine with every component with every PM on each component (which I have a table for that, which also lists the frequency that they need to be performed) and then tell me if the PM is due or not.
Current setup is I have a table with all of that data mentioned above, a form that maint personnel fills out saying they completed whatever PM and on whatever date. I then query that information with the table that has all the PMs listed to pull the frequency at which the PM needs to be performed, then have a form pull all of that data from the query and run some functions to compare dates and tell me "Overdue" or "Good". I found that if I enter the same exact PM it just adds a new line and says "Good" rather than updating the line that is already there that says "Overdue". Snapshot of an example test I did to see if it would update or not.
Any suggestions? or questions about what I am trying to say?
I have the form pulling its data from a query which I have unique values turned on. The query has report#, machine, component, PM, tech, datecompleted, and frequency. I have the form pull that data and compare datecompleted to today's date to tell me if it is overdue or not. All of that works great, but I only want it to show me the most recent PM performed per component per machine. In the query the unique value seems to only be the report number; it repeats machines and components and PMs. I'm not sure how to get it to do what I want.
I essentially want to have a list of every machine with every component with every PM on each component (which I have a table for that, which also lists the frequency that they need to be performed) and then tell me if the PM is due or not.
Current setup is I have a table with all of that data mentioned above, a form that maint personnel fills out saying they completed whatever PM and on whatever date. I then query that information with the table that has all the PMs listed to pull the frequency at which the PM needs to be performed, then have a form pull all of that data from the query and run some functions to compare dates and tell me "Overdue" or "Good". I found that if I enter the same exact PM it just adds a new line and says "Good" rather than updating the line that is already there that says "Overdue". Snapshot of an example test I did to see if it would update or not.
Any suggestions? or questions about what I am trying to say?
Last edited:
