CanvasShoes
Registered User.
- Local time
- Today, 05:17
- Joined
- Sep 25, 2009
- Messages
- 25
The dates in this ancient (not my original data, it's data somehow copied off of an old obsolete computer system that I'm just trying to rescue and organize), are formatted like this - 6/19/89. My query is written such that I get a sum of all like material from each supplier.
The purpose is to show a total weight for each supplier for each specific material type so that I don't have 4 gazillion records for each of the deliveries of eggs from farmer Joe (just for instance). I have ONE entry for Farmer Joe for eggs for the total he delivered over a year's period (or more). And maybe a separate record from Farmer Joe for the 20 gazillion deliveries of milk (or something like that).
Anyway, I put the column containing the delivery date in the query twice, once with "First" and once with "Last" (the data came to me with only a delivery date column, I am hoping I don't have to manually split it all up). It seemed to work okay, but the first date is actually older than the last date. It's probably something I did wrong, (and/or crappy data to begin with), but I'm hoping someone might be able to help.
(PS, there is no Farmer Joe )
The purpose is to show a total weight for each supplier for each specific material type so that I don't have 4 gazillion records for each of the deliveries of eggs from farmer Joe (just for instance). I have ONE entry for Farmer Joe for eggs for the total he delivered over a year's period (or more). And maybe a separate record from Farmer Joe for the 20 gazillion deliveries of milk (or something like that).
Anyway, I put the column containing the delivery date in the query twice, once with "First" and once with "Last" (the data came to me with only a delivery date column, I am hoping I don't have to manually split it all up). It seemed to work okay, but the first date is actually older than the last date. It's probably something I did wrong, (and/or crappy data to begin with), but I'm hoping someone might be able to help.
(PS, there is no Farmer Joe )