I use Access to create queries for information on product that is presented on a regular basis. I need to add an element for time to determine if 2 products have been presented greater than 1 time, only list them if there were done within one hour.
I usually query for Date, time, location, amount, product id, etc. Need to determine if there has been the same 'product id' presented greater than 1 but only if within one hour's time.
I am absolutely no pro with Access, I use it on a regular basis like every day as of now and can bulid and change queries, tables, macros, etc. Thanks sooo much if someone can help here!
I usually query for Date, time, location, amount, product id, etc. Need to determine if there has been the same 'product id' presented greater than 1 but only if within one hour's time.
I am absolutely no pro with Access, I use it on a regular basis like every day as of now and can bulid and change queries, tables, macros, etc. Thanks sooo much if someone can help here!
