Ok, I have a series of 4 queries and I want to shrink it to 3. There is a datevalue function that work in one make table query but not the previous make table query where the date is originally pulled from. datevalue: DateValue([actiondate]) is what I use. "actiondate" has a date and time in it but I am trying to convert it to just show teh date to work for the query that runs after it. Any ideas on how to fix. Like I said, it works where it is but I want to move it up one so I would only have 3 queries to run instead of 4.
Bowes
Bowes
