Search results for query: *

Thanks. If one ID has one department A or C and another one null I don't want it.

Say I have a table with 2 columns, ID and DEPARTMENT. ID DEPARTMENT 1 A 1 B 1 C 1 D 2 B 2 D 3 B 3 D 3 E 4 NULL I need a select that will give me the ID's who do not have a corresponding DEPARTMENT A...

Thanks, I tried it but i am only getting one record instead of around 1000. :)

I have 2 queries (queries 1 and 2 below) and I want only the rows that are common to each. Then I want to exclude from that result the rows I get from queries 3 and 4. Query #1: select distinct(a.id_num) from v_aldr a,v_gift g where a.id_num = g.id_num AND (a.org_typ_1_cod = '1') and...

Awesome thanks.

Here is my question: I have s eimple table called giving_by_date which contains 3 columns ID, Amount and Date. I need a SQL statement to get the 3 latest amounts for each ID number in the following table. ID Amount Date 1 10 20051001 1 15 20050223 1...

Perfect! Thanks..

I have a stored procedure that contains a parameter that may have multiple values or may be null. If I pass in one or more values for the parameter it works fine but if I do not pass in a parameter it gives me only the records that have a 'null' value instead of all the records. The code is...

I was wondering if anyone has done anything similar to this or knows how to do it. What I want to do is create a link or button on a web form that when pressed opens up a word template and populates it with values from the web form. I'm thinking I can use javascript to do this? Any ideas...

I was wondering if anyone has done anything similar to this or knows how to do it. What I want to do is create a link or button on a web form that when pressed opens up a word template and populates it with values from the web form. I'm thinking I can use javascript to do this? Any ideas...

I am looking at something someone else wrote, so bear with me. Basically it is an Outlook calendar app. There is a pulldown menu with 2 links on it. The problem is that when I click on them nothing happens. I go into the Outlook toolbar, right click Customize and can see the macros i want...

I am looking at something someone else wrote, so bear with me. Basically it is an Outlook calendar app. There is a pulldown menu with 2 links on it. The problem is that when I click on them nothing happens. I go into the Outlook toolbar, right click Customize and can see the macros i want...

Cool thanks. I will try it.

I tried it but I am still having the same problem. Thanks for trying though! :)

I have the following code which opens a word document template and does a mail merge using an access query. Everything works fine but an extra copy of access opens and I want to be able to close it. Any help would be great. Here is the code. Public Function MergeIt() Dim objWord As...

Duh! Thanks! I needed a 2nd set of eyes to see that. I appreciate it.

I am trying to check if a folder exists, if it doesn't I want to create it. This works no problem. The seocnd part is that I want to move a file from one folder to another but I keep getting a Run Time Error '5' Invalid procedure call or argument. It must be something stupid I am not seeing...

I am trying to check if a folder exists, if it doesn't I want to create it. This works no problem. The seocnd part is that I want to move a file from one folder to another but I keep getting a Run Time Error '5' Invalid procedure call or argument. It must be something stupid I am not seeing...

On a windows platform.

Does ayone know how to write a script which detects the status of an FTP server and then indicates on a web page whether the server is up or down. Any help would be appreciated. Thanks!