Date type lost in 2nd query

[Mary]

I have a query that compares dates from two tables and displays the right
one. In that query the date data type is Date/Time. When I use that query
in another query to add additional details, it's no longer a Date/Time data
type. The issue I have is trying to sort by Week on a Report. When I try to
sort on the date field, it isn't a Date/Time data type in the last query. If
I use the first query as the record source, it is a Date/Time data type. I
need to use the 2nd query with all the details as the data source, but need
to keep that data type. Can you help?

 

[Marshall Barton]

I have a query that compares dates from two tables and displays the right
one. In that query the date data type is Date/Time. When I use that query
in another query to add additional details, it's no longer a Date/Time data
type. The issue I have is trying to sort by Week on a Report. When I try to
sort on the date field, it isn't a Date/Time data type in the last query. If
I use the first query as the record source, it is a Date/Time data type. I
need to use the 2nd query with all the details as the data source, but need
to keep that data type.

You may be doing something (calculation?) to make the query
think it's a text field. How is the field used in both
queries?

 

[Mary]

I'm using an IIF statement to pull the date in. There will be a date in one
of the two queries, but not both. Maybe I should use a union query first to
get all the dates in one query, then use that query in my final query?

 

[Mary]

Union query worked, this is working now.

You may be doing something (calculation?) to make the query
think it's a text field. How is the field used in both
queries?

 

[Marshall Barton]

I doubt that you need to use a UNION query, There's
probably something about the IIf that's confusing the query.
Take a look at http://allenbrowne.com/ser-45.html
There may be something there that sheds some light on your
issue.