Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query Using a Combo Box and Month to Date
FancyPrairie I tried the above and when i input December the Months are text so the return value is all months that have A, B, C, Or D. IE i get April, August, and December. dhookom I changed the name of the field to ShipmentMonth. I also added a field that will convert the Month to a Number...- blake3395
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Query Using a Combo Box and Month to Date
Hello I have a query with 3 fields. Budget Owner (text) - Total Charges (Sum Currency) and Month (text). The Month's criteria is based on a combo box from a form. When the user selects a month I would like the query to retrieve the totals from the month selected plus all previous months. I have...- blake3395
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
