Recent content by welshone

thanks les, I understand !

unfortunatley I cannot change the structure. I have more fields I wish to display, so unioning the data will not work will it ? the data looks like : name access jan feb mar apr may ws 12 y u y n rt 11 u u ek 11 u y y y

hello all, how can I do this : I have a table with fields jan, feb, mar, apr, jun, and so on , in each of these fields is either a null or some value. I want to beable to run a query so I can input a month and bring back data for that month that is not null. something like : select [chosen...

no there is no primary key. however, I think I've asked the wrong question, this is only one part of it, what I want toachieve is : if data in table1 can be found in table2 then update the information, if the data in table1 cannot be found in table2 then insert the data. the tables look like...

hello, how can I update table1 with data from table2 where table2.field1 = table1.field1 AND table2.field2 =table1.field2 this is with ms access 2000 thank you

thanks, I will keep trying this, I think you are right about the formatting, my daa starts off in a database with the space as a varchar, I'll convert it to a number. thNanks for the help

my data looks fine, the drive space can be like this though : 22.50 18.88 36.00 but this shouldn't have any affect should it ?

I would need the data in a format like : server drive 12/7/04 13/7/04 svr2 C 10 10 svr2 D 80 82 testsvr1 C 40 44 testsvr1 D 50 50 like that.

the data I am hoping to see what be the true value for each drive on each date, then I could create a line graph mapping this info.

no mate, that hasn't worked. when I llok at my dat , I choose differnt field settings for the space only count displays data, every other function shows 0.

hi, I have tried that but it puts the space as count of space, I need to actual number.... how cna I do that ?

hello, hope someone can help me with a line graph. I am attached to a datasource that is a table setup like this : servername drive drive_space date testsvr1 C 40 12/07/2004 testsvr1 D 50 12/07/2004 svr2 C 10 12/07/2004 svr2...

hello, how can I use a SQL server 7 stored procedure instead of a table for my crystal report ? version 8. I am trying to connect via ODBC but can only see my tables, ( no SP's can be seen) thank you for any info.

doh. its been a lonnng day ! thanks.

I've tried this ,but its not working. I am submitting the form to the next page, I try to do a response.write request.querystring("servername") but nothing is there ?