Pls help, i need to make this program work asap. (1 Viewer)

[homer.favenir]

how can i sum the [total records:] field of lv.tbl?

i made a text box and in control source i place a code:

select
Sum([total records:])
from [lv]

but it didnt work.

and also how can i total the records in text box?

thanks

 

[agehoops]

Can't see that it'd be quite as simple as that unfortunately.

You could create a query that would do a total of that field from the table itself rather than the list box, then make the source of the text box you've created that query???

 

[homer.favenir]

ok
thanks

 

[agehoops]

No problem

 

[homer.favenir]

i made a new query
and i use lv table.
in that query i total records field only.
and in the criteria
="sum"

is that right?

thanks

 

[homer.favenir]

im on a query design.
field: expr1: sum ([total records])
table: lv
sort:
show: check
criteria:
or:

and then in text box, control source is the query.
is that right?

thanks

 

[homer.favenir]

adrian,
thanks, my manager and team leader were impressed in the program youve just made, and they suggests to add some field, like Due Date and will sort accordingly, anyway i made some adjustments and add Due Date field. and now we are using it for a dry run.

Thanks for the help.
God bless
homer