Search results

held against her

touch of turquoise

I figured as much; that's why I didn't reply :) There were some other good ones yesterday too....

Read the fine print.... http://www.google.com/intl/en/landing/nose/help.html

No worries, now that I know what fixed it, I will research it more finely... Thanks again.

Hey Brian, That did the trick. Thanks a lot. Do you know why that is necessary here? The Select statement on it's own came up with the 4 records...

It's a Bill of Material So the SYSADM.REQUIREMENT is made up of all the child parts for every BOM in our system. One of the columns in this table, called WORKORDER_BASE_ID, contains the BOM number for the child parts. I am trying to reduce this list firstly to all the child parts of only the...

Hi Brian, I am trying to delete from the SYSADM.REQUIREMENT table. I only want to delete records that have a BOM (part ID) that is contained in my PartTable table.

The Select Query I have shown above is does select the records I want to delete. So I did try as you suggested Alan, by simply change the Select Query to a Delete Query, and that is where I get the error. This is what the SQL looks like: DELETE SYSADM_REQUIREMENT.*...

Hi, I am trying to create a Delete query. I am trying to delete a specific part from multiple BOMs in my database. I have a table of the BOMs that I want to look in. I called this table PartTable. I also linked my database table SYSADM.REQUIREMENT which contains all the requirement parts...

I have voted a few times...

oh what memories

You may be able to use the formula method described here: http://www.xl-central.com/sum-single-criteria-multiple-sheets.html using SUMIFS instead for multiple criteria. e.g...

me turning back

I think there should be double quotes around the COUNTIF criteria, not single quotes e.g ="=COUNTIF($A1,""*16785*"")>0"

Typical general nonsense

in Jane's face

See http://support.microsoft.com/kb/78113 you can "work around" with ROUND() e.g. =ROUND(F1+0.01,6) copied down.

No problem today for me either....

Perhaps using: http://tinyurl.com/