Search results for query: *

In the case where a common Field1 like "Test1" has the values "High", "Medium", and "Low", and I want it to return "High". "High" is neither a Min or a Max... can you give me an example of a custom aggregate function? Or do you know where I can find the code behind inherent functions like Sum...

Skip, is there a way to create a custom function, similar to "Max" or "Min"?

Hello, I am trying to build an aggregate function in VBA to be used in an Access query. Here is an example of the data that I want to query: Field1 Field2 Test1 High Test1 Medium Test1 Low Test2 Low Test2 Medium Here are the results I would...

philhege? do you have any ideas what could be causing this error?

Line 67 is the code to write the content of the field in the recordset to the Stream object: mstream.Write rst.Fields("doccontent").Value

I am trying to run a DTS package using the ActiveX task to export files from a table in SQL Server using the ADODB.Stream method. I am using the following code: Connection: set myConn = CreateObject("ADODB.Connection") myConn.Open = "Provider=SQLOLEDB.1;Data Source=servername;Initial...

I think that using the ActiveX task I may be able to achieve what I want. Currently, I have a VB exe that does this... however, I'd like to run it on the server side... thus the use of DTS. thanks, ejc

Rob, Thanks for the advice. I just placed a request to have that stored procedure created on the server. Hopefully I will be able to create a DTS that loops through that stored procedure to extract all of the files I need to the appropriate locations. Thanks, ejc

Hello, Within a database we are saving files as the image data type. I would like to create a DTS package to export these files to a network directory. Does anyone know of any examples that show how to do this? Or does anyone have any basic code that does this? Any help would be greatly...

Ken, Thanks for the help... as I find time, I'll have to look into on-demand subreports. Thanks again, ejc

Is there no way to determine which field is being drilled into?

Ken, Thanks for the tips... I haven't been able to get the on-demand reports to work properly. Do you know of a good resource for these? Also, using grouping and drilling down through the cross-tab I have created thus far is working well; however, is there a way to capture the origin or...

I am trying to create a cross-tab through which users can drill-down to the detail underlying information. Any suggestions would be greatly appreciated. I've tried using any combination of charts which support drill-down, but none of them have the effect of the cross-tab. Thanks, ejc

bill... thanks for your remarks. i just recently realized you could mark responses as helpful... i guess i just didn't really pay that much attention to it, or thought that the site administrators marked different suggestions. going forward... it's something i will definitely make sure to be...

morriskc, i'm not entirely clear on what you're trying to do... do you wish to create one column with the values "hardeners", "resins", etc. as the values? if so, then you can do this using an "Update" query... another option is to use an INSERT statement where...

I have a table that has data organized as below: ID Month Amount 1 1 100 1 2 125 1 3 200 1 4 210 1 5 30 1 6 70 2 1 10 2 2 37 What I need to do is have a sum which satisfies the following IF statment: If...

leslie... it's a saved query... here's the SQL behind it... basically, i'm using functions to try to avoid having to create a monstrous SQL statement in VBA... but it's looking like i may not be able to avoid it... unfortunately: SELECT tbl_Model.Month...

here is the code that i'm using for the creating the criteria from a listbox... the problem is in the "critType = critType & " OR " & ctl.Column(0, varCriteria)" part of it... for some reason the query isn't recognizing the way that i'm concatenating the string together using...

I'm trying to use a function to set the criteria for a query. When I use the following code, it works fine, where critType is my function: critType = "D" However, when I try to use any sort of operator, my query doesn't work: critType = "Like '*'" critType = "'D' OR...

I have a table imported from Excel which is set up like a Crosstab query. For instance, the data looks as follows, where the numbers as columns are months: Year Name 1 2 3 4 2001 aaaa 100 120 150 20 2001 bbbb 50 75 80 100...