RE: Default Value from last record in table


By the way, my field is CURRENCY.

I found here a solution for TEXT and COMBO BOX but not for numeric fields
and frankly I do not know how to "change" the so it will work with numeric
fields :(

"Meirav" wrote:

> Hello,
>
> I am trying to get a field on my form to have a default value based on what
> was entered in that field on a previous occurrence (record).
>
> I tried using DLast, but I read it was unreliable...
>
> Does anyone have a better suggestion?
>
> Thanks,
>
>
.

Relevant Pages

  • currency symbol in reports
    ... I would like to make the currency symbol on all numeric fields in a report ... based on user selection. ... However the query which drives the report has the currency code (USD, GBP, ...
    (microsoft.public.access.reports)
  • RE: Default Value from last record in table
    ... By the way, the field is CURRENCY. ... "Meirav" wrote: ... > Does anyone have a better suggestion? ... Prev by Date: ...
    (microsoft.public.access.forms)
  • RE: How to compare fields
    ... > I need to compare three numeric fields and pick the greater of the three; ... > will then have to use that number in subsequent calculations. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Column headers for exported data
    ... is that the numeric fields do not export alphanumeric ... exporting, I end up getting a blank in the export. ... Sam ... Prev by Date: ...
    (comp.databases.filemaker)
  • How to return the max value from expression-list?
    ... In an Access 2003 SQL Select-query, I want to put the max of a list of ... numeric fields from each table row into a new variable, ... but now errs as having the wrong number of arguments. ... Prev by Date: ...
    (microsoft.public.access.queries)