Autoeng
Why me?
- Local time
- Yesterday, 23:21
- Joined
- Aug 13, 2002
- Messages
- 1,302
Working of a db for another department and need some advice as to best way to accomplish this query and display of data.
Data collected...
Date...........WU....Series...Shipped
01/01/05...10001...D187......Yes
01/01/05...10002...D187......Yes
01/01/05...10003...D187.......No
01/01/05...10004...F001......Yes
01/02/05...10005...D187......Yes
01/02/05...10006...F001......Yes
01/02/05...10007...G004......Yes
I am collecting data for units shipped = Yes by day and total by month so results are...
Series...01/01/05..January
...........Daily Qty..Mth Qty
D187..........2...........3
F001..........1...........2
G004..........0...........1
Now what I would like to do is put start and stop date fields on a form with an query execute button that would fire both queries and return the results on the form but I can't seem to figure it out.
I tried to combine the queries to give me one set of results and no matter how I join the queries I wouldn't get the results I wanted. It would drop the series from any that the daily ship = 0 like...
Series...01/01/05..January
...........Daily Qty..Mth Qty
D187..........2...........3
F001..........1...........2
.................0...........1
I wanted to keep this simple because it isn't mine and I don't want to invest a lot of time in creating this simple little interface (just typing this is more time than I wanted to spend) so I really wasn't wanting to create a start and stop date entry form which would fire the queries to a report, blah, blah, blah. Just put it all on one form.
I'm sure I'm missing something simple but it isn't a subform because that won't let you display continuous. Anybody willing to propose a simple solution?
Thanks
Data collected...
Date...........WU....Series...Shipped
01/01/05...10001...D187......Yes
01/01/05...10002...D187......Yes
01/01/05...10003...D187.......No
01/01/05...10004...F001......Yes
01/02/05...10005...D187......Yes
01/02/05...10006...F001......Yes
01/02/05...10007...G004......Yes
I am collecting data for units shipped = Yes by day and total by month so results are...
Series...01/01/05..January
...........Daily Qty..Mth Qty
D187..........2...........3
F001..........1...........2
G004..........0...........1
Now what I would like to do is put start and stop date fields on a form with an query execute button that would fire both queries and return the results on the form but I can't seem to figure it out.
I tried to combine the queries to give me one set of results and no matter how I join the queries I wouldn't get the results I wanted. It would drop the series from any that the daily ship = 0 like...
Series...01/01/05..January
...........Daily Qty..Mth Qty
D187..........2...........3
F001..........1...........2
.................0...........1
I wanted to keep this simple because it isn't mine and I don't want to invest a lot of time in creating this simple little interface (just typing this is more time than I wanted to spend) so I really wasn't wanting to create a start and stop date entry form which would fire the queries to a report, blah, blah, blah. Just put it all on one form.
I'm sure I'm missing something simple but it isn't a subform because that won't let you display continuous. Anybody willing to propose a simple solution?
Thanks
Last edited: