March 14, 2006 at 7:39 pm
am wrestling w/ a calc and syntax:
in Form1 user selects a value 500 from Listbox1
Existing Table1:
Loc Ref Quant Series
A 1 1350 1350
B 1 1000 2350
C 1 400 2750
C 2 350 350
D 2 600 950
-------
in plain english - above table1 Series runs sequencially for Ref 1 across
multiple Locs and resets when there is a new Ref 2....this table is in place.
needed query result based upon the 500 selected value (which next user might
select a different value) - the needed Boxed value can only increment in the
selected value (i.e. 500) but not exceed the Series level.
Query Result:
Loc Ref Quant Series Boxed(this value from form)
A 1 1350 1350 500
A 1 1350 1350 1000
A 1 1350 1350 1350
B 1 1000 2350 1850
B 1 1000 2350 2350
C 1 400 2750 2750
C 2 350 350 350
D 2 600 950 850
D 2 600 950 950
--
I have the query built so it will accurately re-duplicate all the needed
repeated records - it is only the Boxed column values that are missing; I've typed in what the values should be and am wrestling with the math/syntax/sql for the Boxed
calculation column....and bringing in that value (500 in this case) from the
form as part of the calc......
much thanks to those further into sql than I am at this point to help on this.
March 16, 2006 at 12:15 pm
Hi,
I think that your particular situation is much too difficult to understand without more detail.
jg
March 16, 2006 at 1:40 pm
I've over-explained....here is the essence:
Have this Table:
Loc Ref Quant Series Boxed(this value from form)
A 1 1350 1350
A 1 1350 1350
A 1 1350 1350
B 1 1000 2350
B 1 1000 2350
C 1 400 2750
C 2 350 350
D 2 600 950
D 2 600 950
Need a sql statement that will return this:
Loc Ref Quant Series Boxed(this value from form)
A 1 1350 1350 500
A 1 1350 1350 1000
A 1 1350 1350 1350
B 1 1000 2350 1850
B 1 1000 2350 2350
C 1 400 2750 2750
C 2 350 350 350
D 2 600 950 850
D 2 600 950 950
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply