User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Legacy and Other Languages section within the Software Development category of DaniWeb, a massive community of 456,479 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,761 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Legacy and Other Languages advertiser: Programming Forums
Views: 1027 | Replies: 0
Reply
Join Date: May 2007
Posts: 6
Reputation: tonik69 is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
tonik69 tonik69 is offline Offline
Newbie Poster

query in access 2003

  #1  
Aug 29th, 2007
I have the arrays
EMP (EMP_ID(PK), Name, PROJ_ID(FK))
PROJECT (PROJ_ID(PK), name)
SALARY (SAL_ID(PK), date, amount, EMP_ID(FK))


I have done the appropriate relations and i want to take something like this:
wesuppose that EMP name is George and the project is storage
then i take something like this:



George storage 22/2/2007 $2000
George storage 2/2/2007 $3000
George storage 5/7/2007 $100
George storage 10/11/2007 $1200

but i want to take something like this:

George storage 22/2/2007 $2000
______________2/2/2007 $3000
______________5/7/2007 $100
______________10/7/2007 $1200

I'll appreciate any help...
thank you in advance...
Last edited by tonik69 : Aug 29th, 2007 at 2:12 pm.
AddThis Social Bookmark Button
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Legacy and Other Languages Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the Legacy and Other Languages Forum

All times are GMT -4. The time now is 2:42 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC