Search results

  1. K

    calculation based on a previous record

    Hi, I have a table full of meter readings. I want to have a field called consumption which looks at the reading just entered for that month and then subtracts the previous months reading for that meter which leaves the consumption. Can I get a formula that can work this out automatically?
  2. K

    Is not null not working correctly

    can anyone tell me why in my query, when i add the criteria 'is not null' some blank cells still appear. i have a table with emails in (text data type) in and whenever i run a query and add the criteria 'is not null' most of the records without an email disappear in the results but 1 or 2 still...
  3. K

    hiding blank fields in query

    can you hide a field in a query if the results of that query have a field that has no data within it? its a parameter query so it could be a different field that needs to be hidden each time thanks in advance
  4. K

    Double Click Event

    Hi, I have a form which has a tab control on it. The form itself is just based on 1 table (tblCustomers). The tab control has 2 pages. Page 1 shows some fields from tblCustomers. Page 2 of the tab control shows 2 embdedded forms. Those forms are based on queries created from...
Back
Top Bottom