I'm creating a query in Access 2010. My query is calling for a long date (Full date and time). I also want a second column to show me just the month number. I have two columns calling to 'Ord_Bookdate' from table 'DBO_Orderheader' to get my date. I looked on the inter-web and found that naming the second column's field as " Ord_BookdateMonth([Ord_Bookdate])) " DOES cast my date from the long date to just the month number as long as I do not add the table name of where that field is located. When I add the table name, I get the popup message " Extra ) in query expression 'dbo_orderheader.[Month([order_bookdate])) ". Now, I would just leave it be and move on; HOWEVER, I need dates for other things as well that are on different tables and, because some of the field names are the same on different tables, I need to define which table I want the field from; otherwise, I would get the error message " The specified field '[stp_arrivaldate]' could refer to more than one table listed in the FROM clause of your SQL statement. "
Soooo, I need to know how I can have the long date and just the month number on the same query that is pulling from the same field and the same table...
I've attached three pics that show the popup messages and the way my query is set up. PLEASE help me figure this out.
Thanks in advance.