Search results

  1. C

    Date Range Automatically Input Onto Header

    I have managed to do this before where I have a form running from a query that has a prompt in the criteria such...[Enter start date:].by using an unbound text box and entering [Enter start date:] as the 'control source' the date input is automatically updated in the header. But... and there is...
  2. C

    Sub-totals and totals on a Report

    On my report that I am designing I want the report to total by group, not all the records on the report. My report is set out like this:~ Task Job Number Fund Name I want to know the total amount of records under the fund name for each task. All the records are grouped by 'Task'...
  3. C

    Duplicate Data Entry

    Is it possible for a database to recognise that duplicate has been input on a specific date? For example, my database has the same information input onto one particular field daily, however, the other fields do change. Want I want to know is if a user goes in and enters the details more than...
  4. C

    ABS Function

    Can somebody please explain to me the ABS function, how it works and how it should be used?
  5. C

    Grouping in Reports

    I am trying to run a report that has a list of fund names on it and the detail is broken down to a very low level. However, when reporting this information the management team only wants to it on a high level. So what I want to do is this. For instance if Sarah, John, Marlene and Richard are...
  6. C

    Text Box

    I have a text box on my form that is behaving strangely. It is set up as a text box and is driven by an IIf statement. When the answer is autmatically input into the field it says either yes or no just as I want it to but........... when the cursor clicks on it it turns into a number and any...
  7. C

    Crosstab Query

    I am trying to produce a report that shows names as a row heading and numerous categories as the column headings, no problem....yet. I am also trying to get the query to total in each row the amount of items for each category were over due. I alsready have a field in the form that calculates...
  8. C

    Help with an Expression

    I am working on a form that has lots for formulae in it. In one particular field I need it to look at two other fields and pick up the largest figure between the two. The two fields that it is looking have both positive and negative numbers in them and it does not recognise that -0.007 is...
Back
Top Bottom