Udtræk fra acces database

You make a query and select the fields which you want to see in the result.
Then in the criteria for the dato field you add the following:
Between Format(DateAdd(\"d\";-30;Date());\"mm-dd-yyyy\") And Format(Date();\"mm-dd-yyyy\")

Then you make a new field by copying this into the field of an empty column.
TheTime: Format(DatePart(\"h\";[date]) & \":\" & DatePart(\"n\";[dato]) & \":\" & DatePart(\"s\";[dato]);\"hh:nn:ss\")

Then in the Criteria for this field you add the following:
Between \"08:00:00\" And \"18:00:00\"

NOTE I amm assuming that the field is called dato.
If not then you need to alter it

There is a little error in the new field part. it should look like this:
TheTime: Format(DatePart(\"h\";[dato]) & \":\" & DatePart(\"n\";[dato]) & \":\" & DatePart(\"s\";[dato]);\"hh:nn:ss\")

But it could also look like this:
TheTime: Format([date];\"hh:nn:ss\")

This is new for me.

Can u please descripe it for me more spec.

You can send thw database to dkTeBrSa@Europe.LEGO.com (.com i spart of the hyperlink)
and I will do it for you then you can see what I mean!

falslev hows it going could you use what I sent?

falslev> Are you gong to close this quetsion?

thanks:o)