Search results

I need to update a ytd-budget field using the curmo-budget field. The table contains one record for each month. The ytd-budget for Jan would be the same as curmo-bud for Jan. Feb's ytd would be the sum of Jan + Feb...etc. Is there a way to update the ytd fields with a 'running sum' feature...

I need to sort an address field by street name only. The address info is stored as: 123 Main Street, etc. Is there a way to omit the number portion of the field during a sort function in Design View?

On a data entry form, I changed the Property/Default value of a date field from Date() to Now() in order to capture the Time protion of an entry-date. However, the qry to select entry-date using... Between [enter From date of entry] And [enter To date of entry] stopped working (returned no...

Is there a way to reverse the sign of a numerical field at data entry time and store the negative results...i.e. a quantity field (shipments) keyed as +100 to be stored as -100? I have tried several input mask solutions but none worked. Thanks for any help or suggestions from an Access novice.