Search results

Thanks, Shuie, I will try that.

Shuie, thanks for responding. Here is more detail. Two partners, A and B, own shares on the stock market. Some are owned by one partner, others are owned jointly in equal part by both. The shares table shows the title of each share and an 'owner' field contains either 'A' or 'B' or, for the...

Increment date: previous date +1 ? Nope, you guys are too deep for this end-user. I only wanted to increment the date field, in a table, or at the most in a select query, just like an Autonumber increments itself, to save me typing in the date each time I add a record at the bottom. You guys...

Thanks Fred. I tried this. It seems to require a form which I had not thought I needed but made one for this purpose. Found the OnEnter in the properties, entered the local version of your <<me.datefieldname = Dmax("[yourdatefield]","[yourtable]")+1>> viz. <<...

Thanks, Dreamweaver, but its way too deep for this end-user. Hmm, we’re very primative here, still on Access 2000 & Pentium III.. Sigh.

Rich: Thank you but my understanding of an append query is to add a whole batch of records to the end of an existing table. I enter each day’s meteorological data individually starting with entering the day’s date. I do not see how an append query helps but suppose that reflects my limited...

Wow, thanks for all the responses. I think I've jumped into the deep end - I'm comfortable with tables, queries & reports, and the relational model, but have no prgramming expertise. I thought there might be a simple function in a data entry query that would give me the next day's date each time...

Very simple question: I just moved a simple daily rainfall record spreadsheet to my Access gardening database. Fields are date, rainfall in mm, temperature etc. and a single record is added for each day. How do I get the date field to increment automatically to 'previous day's date +1'. (No, I...

We have many widgets. Each is owned by A, or by B, or jointly (& equally) by A and B. Every widget has a financial value. How do I produce a report listing all widgets & their values, sorted by value accrueing to each of A and to B? A's assets would = sum of all 'A' widgets + 0.5 value of all...

I have applied the NotInList event of a combo in a data entry subform, to activate a macro that opens another data entry form. This allows the user to enter the item missing from the drop-down list. The macro's next item is Requery but it is not updating the first form: I have to do this...