123dstreet
Registered User.
- Local time
- Today, 12:37
- Joined
- Apr 14, 2010
- Messages
- 122
Hi All,
I have a table with RMA (Return Merchandise Authorizations). This table has many fields, RMA #, Serial Number, Return Date, etc...
My goal is to find how many serial numbers have been returned annually over the last 4 years. Most serial numbers are only returned every 2 years, so I would like to find the total number that are returned annually.
It seems simple, but I can't figure out how pull that total number out of a query.
Thank you in advance for any help!
Dan!
I have a table with RMA (Return Merchandise Authorizations). This table has many fields, RMA #, Serial Number, Return Date, etc...
My goal is to find how many serial numbers have been returned annually over the last 4 years. Most serial numbers are only returned every 2 years, so I would like to find the total number that are returned annually.
It seems simple, but I can't figure out how pull that total number out of a query.
Thank you in advance for any help!
Dan!