Search results

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...

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...

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...