H
Henro
I have this query that selects a lot of date/time fields (all in hh:mm
format). In addition it calculates a number of fields
(e.g.. StartDay, EndDay, Lunch, TotalDay: [Endday] - [StartDay] - [ Lunch].)
I want this information exporeted to a new table on which I want to
calculate averages and sums on all of the fields.
Table Hours (alle date/time fields) ==> Query (adds some calculations) ===>
Table MIS (Management Information System)
If I first use a maketable query (using a lot of NZ) I get a table in which
all the fields are filled. BUT! I cannot do calculations on them. Looking at
the design of the table I see several numeric fields, some Date/Time fields
and a lot of textfields. All fields from the originating query have been
converted to textfields except the calculated fields. Most of those are
numeric fields, although some of them are date/time fields. If I manually
change the desing of the newly built table I can change all the fields to
Numeric and perform calculations on them Acc2000 changes ythe fields without
error's of any kind. Since I don't want to change this manually everytime I
changed the MakeTable Query into a query that fill's the table instead of
replacing it. Another Query delets the contents, guarding the design. But
then I get an error stating that there have been 6012 conversionerrors and
there will be as many NULL fields.
How can I put the information in a new table AND perform calculations on it?
(Specifically Avg and Sum)
Sounds so simple but is posing a real problem here (Hence working on
Christmas :-( )
Thnx for thinking with me!
Henro
format). In addition it calculates a number of fields
(e.g.. StartDay, EndDay, Lunch, TotalDay: [Endday] - [StartDay] - [ Lunch].)
I want this information exporeted to a new table on which I want to
calculate averages and sums on all of the fields.
Table Hours (alle date/time fields) ==> Query (adds some calculations) ===>
Table MIS (Management Information System)
If I first use a maketable query (using a lot of NZ) I get a table in which
all the fields are filled. BUT! I cannot do calculations on them. Looking at
the design of the table I see several numeric fields, some Date/Time fields
and a lot of textfields. All fields from the originating query have been
converted to textfields except the calculated fields. Most of those are
numeric fields, although some of them are date/time fields. If I manually
change the desing of the newly built table I can change all the fields to
Numeric and perform calculations on them Acc2000 changes ythe fields without
error's of any kind. Since I don't want to change this manually everytime I
changed the MakeTable Query into a query that fill's the table instead of
replacing it. Another Query delets the contents, guarding the design. But
then I get an error stating that there have been 6012 conversionerrors and
there will be as many NULL fields.
How can I put the information in a new table AND perform calculations on it?
(Specifically Avg and Sum)
Sounds so simple but is posing a real problem here (Hence working on
Christmas :-( )
Thnx for thinking with me!
Henro