Search results

  1. C

    Show and populate full date range

    Hi – hoping someone can help.. I have a monthly system data report I wish to manipulate in Access. I have created a table to match the 3 fields in the data report; the date, widget ID and number of widgets made. Widgets are made every day (including weekends and bank holidays) but...
  2. C

    Query within the same query

    Am I able to base, say, query field 3 on the results of query field 1 and 2? For example, Field 1 is [Balance]/100 and then renamed “new balance”. Field 2 is [Transaction]/100 and renamed “new transaction”. I then want to enter in the third Field simply, [new balance] + [new transaction]. When...
  3. C

    Splitting positive and negative figures into seperate columns

    Hi, hoping someone can help… I have a table called “Table1” and within it are various columns including a “Transactions” column that contain both credit and debit (positive and negative) transactions. As well as the “Transactions” column in “Table1” there is also an “Account Number” column...
Back
Top Bottom