Recent content by marcon

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...