Search results

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.

Thank you both for the quick responses. I have been doing the repair on my PC which has been upgraded to Windows 10. Are you saying I should be doing the repair from a Windows 7 PC? No. The databases are not split. I have looked into this but, to be honest, don't fully understand it and...

Hello all - The past few weeks we have been seeing a couple error messages on three databases that are linked together. The message is either "Unrecognizable Database Format" or that the database is in an "inconsistent state". It happens on all three databases but not all at the same time...

Hello - I have a table that has fields named Category, SubCategory1 and SubCategory2. I would like to create a query that will select the top three values in each of these fields (i.e. The top three categories are X, Y, Z. Of X, Y, Z: A, B, C are the top three subcategory1's. And finally...

Wow! I have been trying different things since yesterday and couldn't get it to work. I tried formatting it previously with just "General Date" as the format type and it didn't show. Now I formatted and added the exact format as you suggested and it works perfectly! Why didn't I think of...

Hello - I have a field called ScheduledDepart that is a General Date format. I have a second field called ScheduledDepartWithCushion that is a calculated General Date formatted field that adds 1 hour to the Scheduled Depart field. When the calculated field has a time of midnight the time...