I have a table linked to an AS400 table and created a query to use as a basis for some reports. The problem is the AS400 table does not have a date column (field), but rather has 4 separate fields, one representing the century, "DATCC", one representing the year, "DATYY", one for the month, "DATMM", and the 4th representing the day, "DATDD". How can I combine the four fields into one that can be formatted correctly as a date field in Access? I'm new to Access and not familiar with SQL at all. Any ideas?