Recent content by tvett

don't worry, just realised it's a datagrid - DOH!

The Properties Window in Visual Studio .NET appears to be a combined Listview and Treeview (i.e. it has the columns of a listview but some items are expanable nodes like in a treeview). Does anyone know what this control is and whether if is available to developers?

replace the "=" with " like " (without the quotes)

you need to repeat the [chain]= so that it reads :- Sum(IIf([Chain]="1_data",([Current EVDY Net]*2),IIf([Chain]="4_data" Or [chain]="5_data" Or [chain]="6_data" Or [chain]="7_data",([Current EVDY Gross]*0.9),[Current EVDY Net]))) AS [EVDY Net]

the simple answer is YES....BUT assuming you use Outlook or similar you can write code to extract emails from the folders and manipulate any other exposed objects. it's easy in theory but in practice it can become a nightmare. you will need to consider standardising folder names and...

You can use the "IsNumeric" function to find whether a given expression can be evaluated as a number. P.S. Don't use .RecordCount, loop until the .EOF is true.

assuming you have imported the spreadsheet into a table. dim recin as adodb.recordset set recin = new adodb.recordset dim recout as adodb.recordset set recout = new adodb.recordset with recin .open "your import table",currentproject.connection recout.open "your output table do...