Forms Data arranged in rows
Luka
I'm thinking a cross-tab query would be helpful here. However, I don't
believe it will give you something that you can update, only display.
If you need further help, let me know.
--
Rob
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-Having trouble with your database?
-Are you ready to upgrade, but don't have the expertise?
Let the FMS Professional Solutions Group solve it for you.
www.FMSInc.com/Consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Quote:
> HI NG,
> I have a table with "work actions", i.e. I have a EMPLOYEE who does work
at
> a CUSTOMERs place for x HOURS on DATE. Now I want to check the worked
hours
> in a form where I get such a view:
> Customer x Week 12
> Mo Tu We Th Fr
> Employee1 8 7 12 7 9
> Employee2 9 8 7 10 9
> ...
> How can I arrange the HOURS of each employee in the coloumns for the
> respective dates ALL IN ONE ROW?
> Can I arrange them all in one sub form?
> Any help or link would be appreciated very much
> TIA
> Daniel
