Using this
Between DateValue(Date()-(Weekday(Date(),"vbWednesday")+6)) And DateValue(Date()-Weekday(Date(),"vbWednesday"))
in order to get sales from certain dates
Using Access 97 and the field is called Date have changed this field to another name and also chechked that Date/ Time is being...