Michael Walsh please help

  • Thread starter Thread starter 848
  • Start date Start date
8

848

Sorry the reply you sent was a little over my skill
I'm new to this and can do a simple query. I did not know
where to put the statement in the query
My fields are (table1)in that table i have a field that
is (date)one that is (start) & another that is (end) the
start and end are both numbers.
how do i get the statement you sent me into a query ?
as i stated in my first post i would like the end reading
in the last record to already be in the start field of a
new record Thanks so much for your help!
 
Hi,
You could try this in the default value for your text box that
displays start.
=DMax("[end]","yourTableName")

Substitute the correct names for the field and table
 
Hi,


It is nice Dan remembered what was relevant to the discussion... :-)

In general, 848, it may be preferable to "continue" in the same original
thread, so the whole context is immediately available... which would
minimize the "guessing" someone knowing the answer would have to do.


Vanderghast, Access MVP


848 said:
THANKS SOOOOO MUCH YOUR GREAT
-----Original Message-----
Hi,
You could try this in the default value for your text box that
displays start.
=DMax("[end]","yourTableName")

Substitute the correct names for the field and table

--
HTH
Dan Artuso, Access MVP


"848" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
.
Click to expand...
Click to expand...
 
Back
Top