Search results

  1. S

    DomValue returns .E + 04 for some fields

    I have got an Form, lets call it Form1. It gets that Data from Query1|Dynaset(inconsistent)| and the Form looks as follows: 1st Dataset: Calculated Data | Data to type in 2nd Dataset: Calculated Data | Data to type in 3rd ... and so on. In the calculated Data part of each Dataset...
  2. S

    sorting a form by a combo box in other form

    Hi! I want to sort my form with a Combo Box in another form. The form frm_1, gets its data from a query qry_1 and the combo is forms![frm_2]![combo1] - it contains all field names from qry_1 I just cant figure out how to make the qry_1 take the field name by which it should be sorted from the...
  3. S

    prevent round

    I have a table with a field for yearly costs. Its type "number" - "Integer". When I type for example 185,90 access automatically rounds the value and displays 186,00. How do I prevent this?
  4. S

    crosstable report

    Well, I have a table with the following fields: B# | L# | cost Where B# is a big unit, L# is a subunit and "cost" is its cost :) What I need is a big overview with ALL B#'s listed on the very left side. And above should be listed all L#'s and the cross of both gives the costs. Like this...
Back
Top Bottom