Search results for query: *

Plase can someone help. I need to send the contents of an excel worksheet via email exactly how you do it if you select: file>Send To>Mail Recipient. Im using excel xp and need to code this in vba. Ive tried the sendmail function but this sends the whole thing. Many thanks Andy

I have the following stored procedure: SELECT mv_rep as Rep,mv_account,aca_name as Name,sum(mv_cost)as Cost, sum(mv_sell_value)as Value, sum(mv_sell_value - mv_cost)as profit, datepart(month,[mv_date])as Month,datepart(year,[mv_date])as Year From movements m1 INNER JOIN ADDRESSES ON(...

Nice simple one but i cant get me head round it. What i want to do is IF the field [pr_Discount]=Y then add 30% to the field [pr_Cost]. All this in one query if poss

bit of a novice, so stay with me a minute...... What i need to get in a stored procedure is the equivilant of several access queries. what im trying to get is a list of customers who havent bought anything in the current month. Then for all of the customers who havent bought in the current...

i have a stored procedure called as_spAnalysis. I have an excel spreadsheet called sheet1. I need to pass to the stored procedure the month and year which gets entered into seperate cells on the spreadsheet (sheet1, a2 and b2). I need to, at a click of a button, return the information and have...

ok here is what ive got. tblRep2: name Postcode andy ec1m 4gg tblNorth: Postcode ec1m4 in tblnorth there are the beginning of some postcodes. In tblRep2 there is a list of companies with their names and full postcodes. What i want to do is select all of the companies in tblRep2...

im trying to replicate a table up to my web server but im getting the following error when i try to input something into the "type field" microsoft OLE DB provider for ODBC Drivers error '80040e07' [microsoft][odbc sql server driver][sql server] the conversion of a char data type to...

A really simple one, i want to have an autonumber generated in my Make table query. Or is there anyway to do a running count? so if I have: Ident Cost Count ashur001 £10 1 ashur001 £20 2 ashur001 £30 3 How do i get the count field?

Ok here is what ive got: tblReports: Account Date Cost Value Target ashur001 01/10/01 £100 £20 £200 as an example. what i need to do is select a date range then have a running total/sum on the cost,value and target for each account in that date range. Can...

Sorry to bug a again but im getting desperate now!!! i need a query that will show a running total of a feild. I have tried DSUM but i cannot get it to work, can anyone help?? please!!!

Hi, I need to have a running sum in "make table" query. i have Value, cost and target i cant do a running sum in a report as i need to make graphs from this information. I dont know of a way to base a graph on a report. Many thanks

Is it true that if you code everything in actionscript rather than animating it with tweens, it will keep the filesize down? as an example, zooming in or shifting a graphic on screen will be smaller file size if you set the x axis and y axis in code rather than animating in the time line? also...

Hi, Please can someone help i havent got much time! Im currently building a Flash website but need to display some web pages within. I think the best way is to put a layer over the swf file in dreamweaver, however I tried this but cannot target the layer with the GETURL action. You can target...