Search results for query: *

Sorry comparison was the wrong word. I have an employee report and I'm trying to create the criteria from a single dropdown and a text box. So if the user wants to see all records where the employee has greater than 8 hours, he would select the ">" and type in "8". or if he wants to see anyone...

Hello, I'm trying to create a query where you can select the comparision and enter in the number to compare. So I have a drop down list with <,>,= and have a text box to capture the numeric value. In the query criteria I've tried Forms!Form.DroplistV & Forms!form.NumV and Forms!Form.DroplistV &...

Awesome, awesome, awesome - much thanks... So simple...

Hello, I need help pulling the status of a single contact from Communicator. I have the send code figured out. Just can't seem to compile the right verbiage for the status. Want I want is an if statment where depending on the status of the contact it will either send an IM or email. I can figure...

and there was much rejoicing... Worked great. Thanks

Hello, I have the following table ID Store# Genre WOS 1 1000 Action 2 2 1001 Action 4 3 1002 Action 4 4 1003 Action 1 5 1000 RPG 3 6 1001 RPG 1 I would like to group the Genre and rank based off WOS, I have it ranking nicely but my problem is ties. For...

Yes to the distribute evenly accross the eligible stores and yes you are correct, I didn't list it but I do have a TitleID and RankID column in both tables. Heres my train of thought, it really doesn't matter what the UPC is only that the rank is A. After I typed the first post I needed to...

Hey guys, here is my reasoning. The tblstore is based off sales volumne. I have a make table query that performs the calculations and creates a temp table that gets over written weekly. And to answer Danvlas question, "For instance, why is UPC 456 assigned to store 1002 and not to 100, like item...

Hi all, Here is my problem, I have the following tables 1. TblStore [Store], [Rank] 2. TblItem [UPC], [Rank], [Store](This is null) TblStore Example [Store] [Rank] 1000 A 1001 B 1002 A 1003 B 1004 B TblItem Example [UPC] [Rank] [Store] 123...

Thanks for the lead, but what I did was I changed the ingCatID to String and IngID to String. So it reads: Function fncRunSum(lngCatID As String, lngUnits As Long) As Long 'Variables that retain their values. Static lngID As String Static lngAmt As Long If lngID <> lngCatID...

Hello I have an issue where I think the solution is simple. I have a table with two columns Type=Text Ert=Number I want to create a query that has a 3rd column that does a rolling sum. Example Black 10 10 Black 5 15 Green 2 2 Green 1 3 I've tried the fncRunSum...