Recent content by ErinL

The null was the problem. I broke it into two separate queries and then create a union query to combine and see all the records. Thank you both for your help!!

Hello all - Thank you all for the responses. Isaac - when qryFlashHoursRP is run by itself there are 8 records returned. When the query I posted is run it only returns 1 record (the one where the WorkCategorySubGrouping field matches with GenOps). Below are the 8 records qryFlashHoursRP...

Hello - I have the following SQL in a query... SELECT qryFlashHoursRP.WorkDate, qryFlashHoursRP.WeekEnding, qryFlashHoursRP.ReportOrder, qryFlashHoursRP.WorkCategorySubGrouping, qryFlashHoursRP.Hours, qryAdditionalGenOpsHours.AdditionalHours, Nz([Hours])+Nz([AdditionalHours]) AS RPHours FROM...

Well dang that was fast! Thank you so much!! :D

Here is a small sample of what is in the original database.

I tried this and it returns the #Error. The fields are not "time" in the sense of AM or PM. They are only an hh:nn:ss format of how long of a period of time.

Hello! I didn't specify on the first import and it imported them as short text fields. I imported a second time and changed the format of the fields to the "Date with Time" option and it didn't import any of the data from those fields. An Import Errors table was created and the error was...

Hello - I feel like I should know how to do this but can't seem to figure it out. :banghead: I have two fields in a query "Goal Time" and "Actual Time". They are imported from an Excel spreadsheet and the imported data type is short text. The data in these fields is equal to the...

Sorry for the delayed response. Yes I did see this information and I talked to our IT department about it. Unfortunately I work for a larger company and we are not able to do this work around as our IT is limited in the registry changes they can make and they are not allowed to make any...

Thank you for all the responses. theDBguy - the latest image going out on our machines is build 1809. Micron - I just recently split the databases when these issues started and I used the wizard in Access that does the split for you. So that is why there are three. Mark - They are all a...

Hello again - I am still fighting this problem. I split the databases, have the back ends out on the network and the front ends locally on the PCs. We continued to see the "unrecognized format" message and had to compact and repair to get them going again. I had one linked table in the...

Thank you for your quick responses. Yes I am working with our IT dept and will have the back end databases on the network drive but will copy the front ends to the local drive of each PC. I am just about to test this scenario by putting the back ends that I created on my external drive out on...

Hello - Currently (and how they have always been set up) each database has it's own set of tables saved in the .accdb file but also have links to tables in the other databases. For example, the database we use for loading trucks has it's own set of tables saved in the actual .accdb file which...

Hello - I have three separate databases that are all linked to each other and that are all used by multiple users. We have been using them for several years without any real issues. However, my company recently started updating PCs from Windows 7 to Windows 10. As they rolled out PCs with...

Thank you for all the info. Looks like I will definitely be splitting the databases in the very near future. Thanks to everyone for the assistance.