M msmuzila Jun 20, 2006 #1 what would the criteria be for a query where i want the filter the SHIP_DATE field for the last three months
what would the criteria be for a query where i want the filter the SHIP_DATE field for the last three months
J John Vinson Jun 20, 2006 #2 what would the criteria be for a query where i want the filter the SHIP_DATE field for the last three months Click to expand... BETWEEN DateAdd("m", -3, Date() AND Date() will get the range from April 19 through June 19. John W. Vinson[MVP]
what would the criteria be for a query where i want the filter the SHIP_DATE field for the last three months Click to expand... BETWEEN DateAdd("m", -3, Date() AND Date() will get the range from April 19 through June 19. John W. Vinson[MVP]
J John Vinson Jun 20, 2006 #3 what would the criteria be for a query where i want the filter the SHIP_DATE field for the last three months Click to expand... BETWEEN DateAdd("m", -3, Date() AND Date() will get the range from April 19 through June 19. John W. Vinson[MVP]
what would the criteria be for a query where i want the filter the SHIP_DATE field for the last three months Click to expand... BETWEEN DateAdd("m", -3, Date() AND Date() will get the range from April 19 through June 19. John W. Vinson[MVP]
