|
I have managed to (using the power of wizards) create the following SQL/Access code. It basically groups the dates togather and SUM's the total money spent at a particular company for that given month in a columnar fashion.
How would I add to the follwoing code:
SELECT DISTINCTROW Format$([Expense].[Date],"mmmm yyyy") AS [Date By Month], Expense.Company, Sum(Expense.Amount) AS [Sum Of Amount]
FROM Expense
GROUP BY Format$([Expense].[Date],"mmmm yyyy"), Expense.Company, Year([Expense].[Date])*12+DatePart("m",[Expense].[Date])-1;
and make it tally a total of all expeditures also and include a column at the bottom for the TOTAL.
I hope I made sense...
Thanx! 
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
Do you want to add this as a report, or a module in Access? 
More info please.
Nick Parker
|
|
|
|
|
Ummm....i'm not sure...
Basically I created a custom form entered data and then viewed it in table form...ran a Query wizard on the data to show only certain info....in the table view I right clicked on the grid and clicke SQL view....whatever that is I guess would be what I want.
Thanx!
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
I have a application that Im working on that I want to be able to write information into different columns and rows of a access database. I really dont care what method is used as long as it gets the job done. The problem is that Im very new to VC and it seems that all the help on MSDN is a little too cryptic for me Can anyone break down a easy way to write to a database. A little detail wouldnt hurt so I can learn from this to.
Thank You,
Sparky
|
|
|
|
|
go to the database forum here on cp and download the ado library by carlos antollini ... it will get you started and the libs make life easier for doing exactly what you are asking
if you have any problems after that just post them here
situations to avoid #37:
"good morning ... how many sugars do you take in your coffee ... and what was your name again?"
coming soon: situations to avoid #38: "...and the dog was there too?"
|
|
|
|
|
Thank You for the reply. Ill give that a try.
Sparky
|
|
|
|
|
Hi!
I have a real basic question. Maybe I'm just too stupid to see the obvious...
But how do you delete a database you have created with the Server Explorer of VS.NET? I can find an option to create new databases but no option to delete an existing one?!?
TIA
Martin
PS: VS NET Prof, SQL Server 2000 Desktop engine
"Kein Alkohol ist auch keine Loesung" - Die Toten Hosen
|
|
|
|
|
What does a DSN do exactly...is this seperate from a connection...?
I was told a DSN is a entry in windows registry, which makes sense...but why would hosting services ask how many you want...?
Do I need a unique DSN for each database file I have...?
Is this why they would offer this option...? Also Why would a hosting company ask how much DB space I want/need...?
How is this different from normal domain space...?
Do they keep the DB in a seperate directory, secure away from the root (thus requiring DSN)...?
How is DB and domain space different, or is this just a method of making MORE money...?
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
Hosting services don't usually use Access databases, so stop thinking about "database files". Database servers like MS SQL Server or Oracle don't have 1:1 mapping from databases to files or directories.
|
|
|
|
|
markkuk wrote:
Hosting services don't usually use Access databases
I was orignally using access, but I now understand why sqlserver/mysql is far superior...
markkuk wrote:
Database servers like MS SQL Server or Oracle don't have 1:1 mapping from databases to files or directories.
What does that mean...?
Thanx!
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
In big database servers, a database isn't a file or a directory on the filesystem. The server simply gets some space from the OS, either files or sometimes raw disk partitions, and manages all space allocation internally. A single file may contain several databases or a database may be spread among several files, but this isn't visible to the database users.
|
|
|
|
|
I did not know that.
Cool, thanx for the help.
Cheers!
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
Wow... so many questions
Well I'll try to answer one by one.
Hockey wrote:
What does a DSN do exactly...is this seperate from a connection...?
DSN just points to connection. So you can change Connection without replacing Connection string in ALL of your code. This is what it for.
Hockey wrote:
I was told a DSN is a entry in windows registry, which makes sense...but why would hosting services ask how many you want...?
Have no idea why hosting company asks how many you want. Usually they won't care about it.
Hockey wrote:
Do I need a unique DSN for each database file I have...?
Yes, DSN should be unique per database/connection. Don't see why you need 2 DSNs pointing to same database with same properties.
Hockey wrote:
Why would a hosting company ask how much DB space I want/need...?
DB space makes sence for SQL server. More space - more data you can store in your database. Because at the end all database stored in files, whatever db it is, SQL, Oracle, Access, etc.
Hockey wrote:
How is this different from normal domain space...?
Depends on hosting company. Usually they have SQL server on separate computer. Also you may have only 2-3 ASP pages, but a huge database. That's why it is separated. For example, the database of the company I'm working in, is around 2Gb.
Hockey wrote:
Do they keep the DB in a seperate directory, secure away from the root (thus requiring DSN)...?
Partially answered ikn previous question, but have to add that DSN is not because of security, but because of easy using.
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
Thanx for feedback.
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|
|
I need to find documentation on ActiveXScript Syntax. Thank you in advance
QMuffs
|
|
|
|
|
If you are creating an ActiveX script inside a DTS package, you can use VBScript, not sure about JScript though.
Do you have a particular question?
Nick Parker
|
|
|
|
|
I just wanted to know if anyone knew where there was documentation because some of the commands in ActiveXScript are not the same as the ones I'm used to in VB.
QMuffs
|
|
|
|
|
qmuffs wrote:
some of the commands in ActiveXScript are not the same as the ones I'm used to in VB.
Understood, when I had to create my first real DTS package I was also somewhat lost, some of the things like:
Main = DTSTaskExecResult_Success
had me confused. There is a really good book on DTS for SQL Server 2000 that I pointed out to my boss, he looked at it and we picked it up, quite a bit of information by Wrox. Here is the link on Amazon to buy the book. Professional SQL Server 2000 DTS [New Window]
HTH
Nick Parker
|
|
|
|
|
Hello all,
I identified that an ADO Recordset would be perfect for a VB app I'm writing that scans information on a server to store in memory. Note, I am not connecting to a database.
I intend to create a table from the findings and store it to a file when the application quits. This would theoretically give me easy access to organize, filter, and cache the information in question.
The problem: How? I can create a RecordSet but I can't call AddNew unless it's Open. If I try to open on a filename, it needs the file to both exist and contain data. If I open with an ADODB.Stream object, I get an error about the stream having no data.
|
|
|
|
|
Well, basicly you need to add fields before opening the recordset, then you can open it and add data as you'd like
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
I am using an ODBC driver that does not return any records when I select asking for only records with a certain field blank.
select * from file where file_field = ''
returns nothing. However,
select * from file where file_field <> ''
does return all but the records where file_field is blank. Other drivers I've used didn't have a problem with this, just saying "where file_field = ''" works fine. Is there another way to designate a blank field that I'm not familiar with?
Ed
|
|
|
|
|
Ed Hill wrote:
Is there another way to designate a blank field that I'm not familiar with?
Ed, are you checking for a Null value:
Select * from <code>[YourTable]</code> Where file_field Is Null
You may be storing blank spaces which is different than just '' and Null values all together. Something like this may work for you depending on your database, if I remember exactly:
Select * from file_field where substring(file_field, 1, len(file_field)) <> ''
HTH
Nick Parker
|
|
|
|
|
THANKS NICK!!!!!
IS NULL works perfectly!
Ed
|
|
|
|
|
Howdy, does anybody know how to connect to an MSAccess database directly (using the file not a DSN) with VC without using MFC?
This database is also encrypted so it has a cmb & wgf as opposed to an mdb.
Some source or examples would be a life saver
I'll be eternally endebted to anybody who can help
Thanks
Desperate Damian
|
|
|
|
|
There are lot of articles in CP like this one:
http://codeproject.com/database/caaadoclass1.asp
Mazy
"The path you tread is narrow and the drop is shear and very high,
The ravens all are watching from a vantage point near by,
Apprehension creeping like a choo-train uo your spine,
Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
