Search results for query: *

Hi JarlH, Thanks for the snippet. When I tried to use, it gives me an error about a mismatched input around the "FROM" where it is expecting a ")" in the expression specification. From this, I have tried to add the additional parenthesis but still get an error. Sorry to be such a pain but can...

Hi... I have some data that contains a column with a URL field. Within the URL field's contents, there are several values that I need to be able to parse out. I can only do this with SQL (i.e. cant write a function since I dont have permissions to register/execute). Can anyone help...

Hi... I have some data that contains a column with a URL field. Within the URL field's contents, there are several values that I need to be able to parse out. I can only do this with SQL (i.e. cant write a function since I dont have permissions to register/execute). Can anyone help...

A function will be more efficient going through a collection of records. The query basically is a join on ip address to retrieve extended attributes per above. select a.ip_address, b.city, b.state, b.zip from ip_address where a.ip_address is between b.start_ip and end_ip There has to be a...

Result would be the original ip address and the extended attributes of the ip address, i.e. city, state, zip.

Hi all... I need help in writing a FUNCTION that will take an IP address and look it up in another table and return its corresponding geography values.( A function is needed as I have millions of records to lookup and brute force SQL does not perform well.) source record: IP Address Date...

On looking through the results, this does NOT work. If the time period is not contiguous (i.e. 1/1, 1/2, 1/3 then a gap, 1/5, 1/6, 1/9, etc. the counts do not sum correctly). Can someone please help? Thanks!

PH -- This worked! BIG THANKS for all your help!

Hi... I am hoping someone smart can help me with this... I have records like this: Type Team Time Period Date #Bugs Auto Accounting Year 1/2/09 10 Auto Applications Year 1/2/09 30 Auto Finance Year 1/2/09 5 Auto Cust Service...

Thanks...I will try that. One question though...Isnt a function more efficient?

Correction...! Only the data for the most recent RecordID and date/timestamp should be returned. Older records for a RecordID should not be returned as part of the results.

Only the data for the most recent date/timestamp should be returned. Older records should not be returned as part of the results.

Not sure I understand. What do you mean specifications and rules? I essentially need to condense multiple records with the same date/time but different old & new values to a single record for a given RecordId. Thanks.

Oh boy...here's the latest problem for the access newbie. My dataset has records that look like this: Field RecordID Created User OldValue NewValue status 6789 3/1/10 1:25:30 AM SVACS In Prog status 6789 3/1/10 1:25:30 AM SVACS Accepted status 6789...

ah, did not know about the 2k limit. bummer as with the exponential increase in data these days, life is not always that simple. Agree that the # of statuses is insane, but it's not my design... Thanks!

Thanks...I will try this and close if it is successful. Appreciate the assistance!

Sample of records in first post. There are about 142 different Status types. Some of the Parent Issues can have many, many Linked Issues. Is there a limit somewhere that I should be aware of?

I did get the first one to work today. It was a typo... The second piece still does not provide all the values as it is limited to the first occurrence...not sure what to make of it. What additional info can I provide to help troubleshoot?

Duane, The cross tab is setup as: Parent Issue > Row Heading Status > Column Heading Linked Issue > Value (Total = First) The error message I receive is: Record is too large. Any thoughts? Thanks!

Duane, Thanks... for the most part this worked but when I ran the cross tab query it gave me an error message that there were too many records. Is there another way to run this to easily (in a scaled manner) to send this directly to a table? Thanks!