Grouping in Access 2007 queries messes up date field

  • Thread starter Thread starter MrDeej
  • Start date Start date
M

MrDeej

Hello!

I have a field which is defined like this: Dato:left([flyttet tid];10).
[Flyttet tid] is a now() value in a datedefined field at SQL table.

When i run query in ungrouped mode it looks like this:
http://bildr.no/view/301115

But when i run query in grouped mode it messes up the field so it appeas
like this:
http://bildr.no/view/301116

The problem is that i dont know how to use dato as a criteria in VBA when
the field contains partly the month name at first.
 
hi,
The problem is that i dont know how to use dato as a criteria in VBA when
the field contains partly the month name at first.
Click to expand...
Instead of Left() use DateValue() to extract the date from your field.


mfG
--> stefan <--
 
Back
Top