Recent content by CSBLUE

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

aaaah brilliant !! thank you SO much :-)

hmmm not too sure what you mean. despite the code above you metion it can be done in design view? After clicking the "totals" button in the design view it by default put "Group By" in each of the columns. Which should i then change to "sum"? When I add "sum" to the "Credit" and "Debit"...

Many thanks both of you for such speedy replies. Mr B – That has worked perfectly in splitting the debit and credit transactions into separate columns – thank you. However, id like to sum the total credits and total debit for each acc. At the moment results are displayed as per the...

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