Search results
-
N
PivotCharts
Ok, I'm trying to create a line graph, with date along the bottom axis, and balance along the left axis. However, when I do this, it shows the dates properly, but all values are at zero. I'm not sure why it's doing this. I've tried diffrent combinatons, but I cannot seem to get it to do what I... -
N
Calculated balance field
I have a banking system, and I need to be able to show the balance as each transaction is made. This is what I have so far: SELECT tblTransactions.lngTransactionID, tblTransactions.lngAccountID, tblTransactions.datDate, tblTransactions.txtType, tblTransactions.curAmount, (SELECT... -
N
Date of this monday
How can I find out the date for whichever the date is of this monday. So, if today is 23/03/2006, then it would give 20/03/2006, which was the date of this monday. Thanks for any advice. -
N
Refrencing a combobox's values
How can I refrencence any value within a combobox (not the one selected)? I want to try and acheve something like this: cboSomething.Value(3) Although that doesn't work. Is this possible? -
N
Returing multiple rows with single nested SELECT?
If have this SQL statement: SELECT (SELECT tblTransactions.lngTransactionID, tblTransactions.lngAccountID, tblTransactions.datDate, tblTransactions.txtType, tblTransactions.curAmount FROM tblTransactions WHERE tblTransactions.lngAccountID=[AccID?]) AS tblTransactionsB, (SELECT... -
N
Data type mismatch in criteria expression. Where?
I am trying to set a recordset, and I keep getting this data type mismatch error, but I cannot see what the problem is. Here's my code: Set rstAccounts = dtbCurrent.CreateQueryDef("", "SELECT [Account ID], [Balance] FROM tblAccounts WHERE [Account ID]='" & txtAccountID.Value &... -
N
Creating a running total calculated field
I have a query, and I want a field that shows the current balance as of that transaction, eg: _________________________________________________________ |__Transaction ID__|__Type_______|__Amount__|__Balance__| |__1______________|__Deposit_____|__£10______|__£10_______|...