Search results for query: *

Thank you so much! I will give it a try and let you konw if it works!! Thank you, thank you, thank you!

Hi, I have a simple ACCESS (ACCESS 2000) form which allows users to search the table by setting 1 or multiple of the 5 different parameters (i.e. customer name, order date, order ID, customer phone number, product name). Some of the parameters use a drop-down menu, and some allow users to...

Happy Friday! I am having some hard time with a query I created... My current query: SELECT Code.h_codeid,Code.h_instance,Code.h_code,Code.h_date FROM Code INNER JOIN Account ON Account.SSAccountID=Code.SSAccountID AND Account._counter=Code.claimlink WHERE Code.h_codeid IN ('DI','PR')...

Hi, We use a communication PC to connect to one vendor's system for cost reason. Sometimes, when end users call the procedure, the PC would try to query and build up a long queue since no results are returned. The wait counter would just keep running. Is there a simple way to monitor the...

Bingo!! I think we have it!! I can't thank both of you (genius!!!) enough:) Thank you, thank you, thank you!! You deserve many stars!! Egghi

Hello George, I ran your query and got an error message... Server: Msg 8118, Level 16, State 1, Line 1 Column 'MyTable.counter' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause. Any idea how we can modify the query? Thanks a...

Hello George and Borislav, I tried Borislav's query and it got REALLY REALLY close to what I want! I validated the result with the data on the table, and there are two problems left! The first problem is my fault... PostDate does not always have to be BillDate - 1. As long as the order is...

Hi George, Sales rep gets credit based on the post date AND IF the order posted is successfully billed in later days. So, Alice gets a credit when order was re-posted on 9/25 and then successfully re-billed on 9/26. Basically, the query needs to find the last billdate for each order and then...

Hi, I am not sure if this can be done, but I sincerely hope someone can help me out. I have a table with data like this: counter salesrep PostDate BillDate -001234 Adam 2006-9-23 00:00:00 2006-9-24 00:00:00 -001234 Alice 2006-9-25 00:00:00 2006-9-26 00:00:00...

Hi Skip, So, I created two queries. The first one is called splitrow(1): SELECT [PRODUCT CODE], DESCRIPTION, [CATEGORY], PRICE,[Modifier 1] AS [MODIFIER] FROM products WHERE [Modifier 1] IS NOT NULL UNION SELECT [PRODUCT CODE], DESCRIPTION, [CATEGORY], PRICE, [Modifier 2] AS [MODIFIER] FROM...

Hello Skip, I was really dumb... I was too focused on vbscript and totally forgot about the power of SQL query! One last thing to bug you: if I do have more than 2 modifiers (say I have 3 modifiers), should I create 2 queries? The first one is modifier 1 union modifier 2, and then the second...

Hello Skip, Thank you very much for the input! The problem with union is that I cannot have more than 2 modifiers. Also, if Modifier 1 is null and modifier 2 has a value, the union query would return a repeated row with no value in Modifier: Procedure Description Category Price Modifier1...

Hi, I am trying to split rows in an Excel spreadsheet. My spreadsheet currently looks like this: Procedure Description Category Price Modifier1 Modifier2 001234 Plastic bag V $12 TC890 TC990 001235 Paper box V $15 TB003 001236 Tin can J...

Hi, I need to write a VBA function that allows users to find specific text in the macro and replace the text with a new text without using the FIND & REPLACE feature in Excel. The macro I wrote imports file with names like filename08072006.txt. I am trying to create an form that allows users...

Hi, I am trying to build a SQL-based simulation tool which will apply complex rules (rules stored on a rule table) to different scenarios. The logic is to throw all the rules onto a rule table, and then create a form which users can enter a scenario (i.e. 21-year-old driver with no DUI record...

Hi, I used autofilter first, and then I would like to delete all hidden rows (the rows that do not meet the criteria. My coded did not work the way I wanted though: Columns("C:C").Select Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:="=HA*", Operator:=xlAnd...

Hi, I am some problem copying data from one sheet and paste it to the first empty row on another sheet. My code: Sub findlastrow() Dim lRow As Long Dim Range As Range ' Find the FIRST EMPTY row by adding 1 to the last row With ActiveSheet ' Determine last row lRow =...

Hi Rdgs, I tried "*", but it did not work. I think it's the <> (not equal to) causing me problem. Any suggestion? Thank you!

Hi, I have 5 columns on the spreadsheet plus rows of header and footer for each page. I would like to delete the header and the footer and just keep the "meat" on the spreadsheet. Here is a sample of the sheet: Good Morning Distribution Page 1 Date: 07/25/2006 BT SalesName...

Dear Skip & Ron, I need to create a new book each day, and Ron's code worked out perfect for my case. Thank you both very much!!!