have to put my Access hat on this week.
I created a table (tblsvctimes)
I created a query(qrysvctimes) using table and created 2 fields using calculations to generate hrs and minutes
I use this query in a subform linked to mainform by svcticketID.
I populate the subform in couple different clients.
Show up fine on the subform...
Table is not populating.
This should be so simple? But, I've been working in Crystal for the past couple months and can't remember stuff and feel like a complete idiot as I've created 10 new db's last year using same scenario...
Help please and Thanks.
:banghead:
I created a table (tblsvctimes)
I created a query(qrysvctimes) using table and created 2 fields using calculations to generate hrs and minutes
I use this query in a subform linked to mainform by svcticketID.
I populate the subform in couple different clients.
Show up fine on the subform...
Table is not populating.
This should be so simple? But, I've been working in Crystal for the past couple months and can't remember stuff and feel like a complete idiot as I've created 10 new db's last year using same scenario...
Help please and Thanks.
:banghead: