Separating a date into day, month and year

[teirrah1995]

I have a word document which links to a query in my table. In one section, it asks for the date of birth, and it must fit into certain boxes. On paper, it looks like:

01 / 01 / 2001 (example)

For it to print into these boxes, I think I need to separate 01/01/2001 into 01 and 01 and 2001.


The data I need this to be filled with is "DOB" in the "Patient Number" query.
Would really appreciate the help.

[June7]

Use Month(), Day(), Year() functions to split up a date value. Example: Year([DOB])

[teirrah1995]

Wow, that's simpler than I thought. Thank you. Do you know where you would put text like that (year([DOB])) if you were in MS Word?

[June7]

Put it in the query. In design view, enter the expression in a cell of the Field row. Access will assign a generic name like Expr1. You may replace it with whatever you want, like YearDOB. Now you have a field available for Word to work with.