Search results

Thanks Jon K...your solution worked perfectly. I really appreciate your explanation as I am not only a 'how' person; but a 'why' guy also. Thanks to Cosmos75, neileg, and EMP as well. Keep up the good work.

Thanks for the info...I think it worked this time.

I included all tables in the Budget mdb...the one in question is Goals. (I do not see the results of the upload...let me know if it was not successful).

Thanks, JohnK, I appreciate your suggestions. I tried the DSUM using the DateValue example (which, due to inexperience, I don't understand...DateField<=DateField ???)...but, it failed to yield the correct result. I tried substituting a date string i.e. #4/30/2006# but got a syntax error. I...

The link to MS Access samples was encouraging...looked just like what I needed. However, there must be something unique about the Dsum function in an Update query...it updated each record selected with the Grand Total of all records...instead of a running sum. The update query was set up as...

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?

My desire for simple soultions always seem to influence the problem definition phase as it has in this situation. The farther I dig into this problem the more complex it becomes. The choices now are: 1. Edit/Balance today's receipts (AM) 2. Edit/Balance today's receipts (PM) 3. Select...

FoFa, x0reset, you are both right on target...maybe a little more explanation will help. Receipts to our inventory system are batched and entered twice daily (AM / PM)...formerly only once a day. A report is then generated to allow for editing and balancing. When once a day entry occurred, the...

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...

Thanks for the suggestions. I must be doing something wrong because I'v tried the expression (Tqty=Tqty* -1) in every event control in properties...nothing works. ...guess I'll have to key negatives using the - key. Thanks again.

Long interger

I tried Tqty=Tqty*-1 in the After Update (as you suggested) but it didn't work...Tqty was stored as positive. Could my expression be the problem?

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.