i need formula day * time

[dino]

i have tabel total days and time now i need the formula
[total days]*[time] dont work
help :banghead:

 

[JHB]

You know where and what you are trying to do we don't, so you need to give more information.

What do you mean with "dont work" any error message/error number?
Where are you doing the calculation, in a form/query/report or??

 

[dino]

first off al i do this in the query
i have the field Workingday`s and time now i need the formule that day`s * time so i have total hours

days are 12 time 8:00 so it is 96 hours
the formele [days]*[time] don`t work give in the query ( fout)

 

[JHB]

Show the SQL string and show your table structure, because one time you call the same field, (so as I read it): [total days], [days] and [Workingday`s].

 

[dino]

see fout
and that the place ware i need code for

 

[dino]

oops no picture now i`ts close in

 

[JHB]

Where you have the "fout" in column "T" type in the following, (you must replace the .. because I can't see the hole fieldname.

T:[Aantaldage[B][COLOR=Red]..[/COLOR][/B]]*[Werkuren]

 

[dino]

That is the problem it don`t work see below

 

[kaherdin]

That is the problem it don`t work see below

In "weergave", click till small small down-arrow, click SQL.
There you will see the acctual SQL statement. Copy that here inside "

"

 

[JHB]

Try the below, else post a stripped version of your database with some sample data in it.

T: [Totaal Dagen]*Format([totaal Uren];"h")

 

[dino]

he thanks this works.