Recent content by Bdaviskar

Thanks Everyone for your Input and Time. On a side note, The logging is simultaneously from a 3rd party data logging software not written in access. When I get some free time, I will try to experiment to see if I can consolidate to one table. As long as size won't be an issue. Thanks again!

Thank you Yes Option 2 would be easier for me to set up maintain. Is there a speed and performance difference between the two options?

Thank you Everyone! The data logging program is connected to access by an ODBC connection. Based off of 4 different triggers (4 different PLCs) I log the data into the respective table. Once logged, I query each table to verify I captured the info and I write back a value to the PLC to confirm...

I have a data logging program that is logging data from 4 different PLCs to 4 identical tables. Each requires their own table and share the exact structure. I have a frontend database that is linked to the 4 tables. Could you explain why one way is better than the other so I can apply to...

Hello, I have 4 tables in which I plan to join with a union query and be able to query information based off of text boxes in a form. The form will have 5 Text boxes that I can use to limit my queries. Is it best practice to: 1) Have 4 separate select queries (one for each table) that will...

Awesome That should work!!!:):) Thank you for your Quick Reply!!!!!

Hello. I am collecting data every hour on the hour and I would like to group this data according to Shift (A, B and C) by Date. The only problem I am having is- how can I keep the overnight shift together as one date? 10pm – 6am I was able to do a simple query where I was able to assign an A...

Thank you for taking the time to help. I will check out and report back.

SELECT tblSessionAnc.IDSessionKey, tblSessionAnc.SessionID, tblSessionAnc.SessionDate, [tblAdministratorsAnc]![LastNameAdmin] & ", " & [tblAdministratorsAnc]![First NameAdmin] AS Administrator FROM tblAdministratorsAnc INNER JOIN (tblSessionAnc LEFT JOIN tblSampleDetailsAnc ON...

Hello, Access 2010 I created 3 find unmatched queries from the query wizard. The first one works great. I can delete a record in the query and it deletes the record in the main table. The second one allows me to delete a record and gives me the pop up box that says " you are about to...

Thank you!

Is it more efficent (Best Practice) to do calculations and if then statments on a reprot or form than it would be to include on a query? I have alot of records that will require a few calculations of fields followed by a nested if then statements I am not sure if I should just wait and do them...

Thank you for answering my post. With your post and some more figuring out I was able to fix my macro on my form. I am not sure if I did it the way you suggest. I am not sure what you meant by goto pointtoContinue. Could you explain a little further? Here is what I did - In Red was the added...

Hello. Short version- I have a validation rule at the table level that stops a macro on a command button on a form that sets a few tempvars and goes to a new record. Since the validation rule gives me the pop up with the validation text explanation it stops the macro and the user sees the...

Thank you That work!