Grouping in Access 2007 queries messes up date field

[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.

 

[Stefan Hoffmann]

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.

Instead of Left() use DateValue() to extract the date from your field.


mfG
--> stefan <--

 

[MrDeej]

Thank you!
Now it seems normal again

hi,

Instead of Left() use DateValue() to extract the date from your field.


mfG
--> stefan <--