Formatting date field results

[DJ_DEF_CON_1]

I have a query that returns a date that is formatted like mm/dd/yy hh:mm:ss The problem I am finding is that I would like the date result of this query to link to another table that doesn't include the time, only the mm/dd/yy. Therefore, I am not getting any results.

How do I get both the query results and the table to find results? The times are not neccesary to me.

Thanks in advance

 

[EMP]

Switch to query SQL View and edit the linking condition of the query and the table in the SQL statement as follows (using the correct names of the query, table and fields):-

FROM queryName INNER JOIN tableName ON CDate(Format([queryName].[DateTimeField],"mm/dd/yyyy")) = [tableName].[DateField]

 

[DJ_DEF_CON_1]

Close - need more Help

The following code is giving me the following error.

"The Select statement includes a reserved word or an argument name that is mispelled, or the punctuation is incorrect" I thilights the word "FROM"

SELECT FROM PICKER_DATE INNER JOIN HR_ATTEND_MASTER ON CDate(Format([PICKER_DATE.START_TM],"mm/dd/yyyy")) = HR_ATTEND_MASTER.ACT_DATE;

Anyone who can help would be greatly appreciated.

Thanks in advance

 

[Mile-O]

Look at the SQL you've written.

You have not said what you are Selecting.

SQL selects fields from a table.

i.e SELECT Forename, Surname FROM tblStaff;

 

[DJ_DEF_CON_1]

Thanks - I cannot believe I slipped up like that!