Recent content by lobhaan

HI! I am going crazy. Never had something like this before with forms. So therefore this question to you; I made simple pivot table form on simple query. The query shows a different total quantity then the total quantity in the pivot table view form (no filters are on). Which is strange. BUT...

Hm yeah I found out that indeed it is difficult. Just in report it is possible (running sum). What I did was export the cumulative report and re import in access. Sounds stupid but doing the job... Thx anyway.

Hi! Sorry I am to bother you. But I was wondering whether it is possible to create a running sum in a query (from each previous record just a simple add up)? I know how to do in report (it is described in the help function) but for a query I cannot find anything. Thx and rgds, Lobhaan

See attached 2 tables as example. I want to connect on VolumeCategory. So: an ID with a certain VolumeCategory needs to get the connecting tariff (talbe 2 = tariff table). In Excel I would use hlookup. In access so far I have manually changed table no 2 to something like table no 3 and then...

thx for the help it has been of great help!

Goodmorning, Got a problem here with Access 2003: got 36 categories (example: volume from 0-0.1=category 1 vol from 0.1-0.2=category 2 etc) and a whole bunch of records (in a table) stating volume per record (0.111, 0.23456 etc). For each record I need to know which category it is. Now in order...