Search results for query: *

Thanks for your response. unfortunately this is before I grouped the data. This is an access97 database running on xp. I wonder if that has something to do with it.

It sure looks straight forward butI keep getting errors. Ultimately, I want to group sales by week, but in just testing this function I keep getting an error. Read and reread the help files.... Any insight or comments are greatly appreciated. Thanks! SalesDate is a date/time data type Sales is...

Thank you. Excellent advice! I will post what happens. Just about to look at Jan and February.

Thanks for the feedback! jtm111 has pretty much described the choices as they actually exist. On one hand, I am being urged to piggy back a Six Sigma project onto what I am working on, but realistic modeling the of variables and communicating that complexity to customers and management is an...

Yes I am opening access up on the server. Thanks for the response!

I have an access db on another server and when I try and run or save the delete query from my desk an error occurs. It indicates that access is looking for the database on my c drive. Is there away around this? Do I have to copy it on my c drive save the query and then put it back out there...

I am working with demand patterns and the seasonality of products. For example, I want to categorize products as having a certain selling pattern. For example. Picture a bar graph with months on x axis and unit demand on y axis, forming a bell curve. Are there data mining tools that would tell...

Thanks Robbie, nice quote!

I am trying to create a comma delimited file but I get ORA-01722: invalid number error. Looked on line, in book, in Faq for solution with no luck, suspect syntax. Can anyone spot my error? Also loc is a VARCHAR2 field. Do I need to include " around it? Any guidance appreciated! SET...

never mind got it thanks

I have a 2 dim array where strcpy puts AB in the left column and CD in the right. It looks like it is working but when I dump the contents of the array I don't get what I want. I want it to print what you see below. AB AB AB AB AB AB AB CD CD CD CD CD CD CD Any help greatly appreciated...

I am tasked with specifically sending an html attachment and not an HTML email or text file or anything else. I can cannot seem to send an HTML file attached to an email. I get an "unspecified error". Is it possible to send an HTML attachment? the method below works fine with a...

Thanks for both responses and especially the rain drop analogy!

Does anyone know how to write a statment that returns the mode from a group of records? ( mode being 50% of values are above and 50% are below) Or is this something not really suited for sql? Any help or direction greatly appreciated.

I am being asked to put a table in the body of an email message. Everything should line up nicely in columns. The data comes from an unformated string. Ex Customer, Part, DateStart, DateEnd, Discount. Of course the length of each field varies so it does not look like a table. ex Greg...

I have to stick a text string into the body of an email for about 200 people. Each text string will be different. I'm thinking I will open a recordset, convert the contents to a text string and put it in a string variable. I realize there are other ways to do things but I am specifically being...

This is a perplexing one. I have 2 functions made up of nearly identical code that transfers 2 identical text files into two identical tables. In fact the only difference in these two functions is one references "..ThisYear" and the other "LastYear". One works and the other...

I want to call about 20 queries in a module , is there a way to copy just the name of the query? Right click, rename, highlight and control c does not work. Any help appreciated1

This is part of my school work but the class is over and now I am just posessed with making it work. I have a .dat file that looks like this : 1 D d1.bmp except there are 52 of these groups of three. I also have a vector of objects where I want to take each group of three data and stick...

Thanks for the response. I'm sorry I was not clear. From a resource standpoint, when is it impractical to use a view? For example , if a query is based on views, is there a point where the queries should be based on tables to save time? Any general guidelines?