sunset1215
Registered User.
- Local time
- Today, 10:23
- Joined
- Apr 7, 2011
- Messages
- 46
hi all,
i have created query that look like this:
example:
Name| Date| Project| date-project
1| 10 apr| eggs |10 apr - eggs
1| 10 apr| bread |10 apr - bread
1| 11 apr| chicken |11 apr - chicken
how can i make it into like this?
example:
Name| Date| Project| date-project
1| 10 apr| eggs| 10 apr - eggs + bread
1| 10 apr| bread| 10 apr - eggs + bread
1| 11 apr| chicken| 11 apr - chicken
pardon the project names. it's the first thing that came to mind.
i have created query that look like this:
example:
Name| Date| Project| date-project
1| 10 apr| eggs |10 apr - eggs
1| 10 apr| bread |10 apr - bread
1| 11 apr| chicken |11 apr - chicken
how can i make it into like this?
example:
Name| Date| Project| date-project
1| 10 apr| eggs| 10 apr - eggs + bread
1| 10 apr| bread| 10 apr - eggs + bread
1| 11 apr| chicken| 11 apr - chicken
pardon the project names. it's the first thing that came to mind.
