Access not filtering on Combo list

[aytee111]

Post the actual Excel file, it is not importing that field correctly, it needs to be converted or something.

[RunTime91]

Update...

I was able to locate the original source data for this table and indeed you are correct... The original source format was a combination of a 'custom date formats' and a 'standard date formats'.

I uploaded a new table making sure all the Shift Times were in standard Excel time format then of course moved those values over to Access' Date/Time format and all worked as intended

Aytee ~ Thank You for sticking with me and for all your help...

[RunTime91]

My question now is, is there a way to fix format of the original table so Access can filter correctly on those times?

Thanks ~

[aytee111]

Recreate the table.
- make a copy of the table, structure only
- run an append query and append all the data - fix the shift fields while doing that
- once it is working correctly (use a query to test it), rename the table back

But why do you need to fix the table? Can't you recreate the data from the original source?

[RunTime91]

Aytee ~ Good Morning...

So would I just fix the original source and re-import?

[aytee111]

Well, that would put you right back to the beginning, wouldn't it? Either that or convert the fields after import. Test each scenario and find the one that works best for you.

[RunTime91]

Update...

First, Thank You Aytee for all your help with this ~!

I made a couple backup copies of the database, and on one I reformatted the source, and on another I simply changed the table format from Medium Time to: h:nn AM/PM;@

Thus far, both solutions have worked (and lessons were learned...)

Thank You again Aytee!