Recent content by Mattkitch80

Hi MajP Sorry for the delay, first chance I have had to get back to this! I have now attached what you are looking for. The data attached is in excel but the sheet names are table names and the data attached is how formatted within the DB and field names are the header names in the columns...

Hi again MajP I cant put my DB up on here due to data protection. I will however (when I get some time!!):( create a copy with some dummy data in it with what you are requesting. Also, I have tested the creating date time fields into one field so will add that to the data set. Thanks again...

MajP. I have responded to your last message but has been held by a moderator to look at first for some reason!:(

Sorry, new to this. The sample was a dulled down version of table which holds a lot more fields. but those are the fields that I thought would be the only requirement at this time? Rules are Mon to Friday are core between times 06:00 & 20:00 (Day) Saturday all day is Unsocial (Sat/Night)...

I have (hopefully) attached some sample data from the DB as an excel doc. The DB is looking at linked excel binary files (for periods) and the unique identifier is the Request ID field as there is no record Id number generated from the DB. Thanks

Hopefully I have replied to this correctly!!:D Thanks MajP for getting back so quickly Not sure How I get sample data on here??:banghead: Day of Start Date TimeMinute of Start Date TimeMinute of End Date Time11/05/201819:00:0006:00:0029/05/201819:00:0005:00:00

Hi all (first post so bare with):confused: Fairly new to access but do know some SQL and have been using this mainly rather then the builder (Just find it easier this way!) I have a date, as date only, start and end times of shifts as time values only in a table . I have a core start time as...

Hi all Relatively new to access.