Previous value of an Expression that is in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Im doing an inventories DB of a product and the closing volume of day1 is
the opening volume of day2. I used dlookup to get the previous value, and Is
called EX1 on Query1;
EX1: DLookUp("[Volume]";"Record";"[ID]=" & [ID]-1)

After doing this I need to use EX1 as a new field on a new expression like
this:
EX2: DLookUp("[EX1]";"Query1";"[ID]=" & [ID]-1)....And this last expression
doesnt work....
Is possible to get the previos value of a calculated field that is in a
Query? I noticed that works fine with tables but when I want to use it with a
calculated value that is contained in a query doesnt work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
how to pass a parameter to a query base of a query that is the base of a report 0
Access Command button to look up and copy data from a query to a table 0
XMLHTTP.send failed with exception.. need Immediate help 0
Different usage of range formats, conflict? 2
Using a value from a previous Record to Perform a Calculation? 1
Is it possible to use DLOOKUP in a query to bring in a value directlyfrom a control box in a form? 3
Special characters 3

Back
Top