Recent content by Vagus14

Works like a charm arnelgp, thanks a lot for the advice.

@Arenel I'll give this a shot right away. Thank you. Let you know how it turns out.

Hey all, I am running Access 2013 (fun version where they took out the pivot tables and query charts) I want to average every five rows and I was wondering if someone could help, here is the data (SQL): Table Name: tblTest ID Value 1 2 2 8 3 3 4 9 5 1 6 4 7 2.5 8 6.5 9 5 10 4...

Hey Mark, Thank you for your take on this. I think I have figured it out. Thank god it is not what you were mentioning above haha. I just had to do a Like Left Join. See below: SELECT tblTemplRateAudit.PN_Ext,IIF( tblTemp_Rates_A.PN_Rate is...

@jleach, great idea with the #2 SQL. I found my quick solution below: SELECT tblTemplRateAudit.PN_Ext,IIF( tblTemp_Rates_A.PN_Rate is null,Dlookup("[PN_Rate]","[tblTemp_Rates_A]","[PN_AC_Category]='"&"Blank"&"'"), tblTemp_Rates_A.PN_Rate) AS Rate, IIf(tblTemp_Rates_A.PN_AC_Category is...

Hey I like solution #2 using LIKE for the join. I will try this right now. Thank you again for your reply and help.

Alternate Solution to an Wildcard Array in a Dlookup Doc thank you for chiming in. I don't need a fast solution but a quality one and I am here to learn. I want the user to be able to edit the wildcards at will in a table and have them pop out on the end query with the correct rates. I...

Hey Plog, Model is derived from PN_Identifer using the code below: Function TestPNModelLookup(strModel As String) As String Dim Categories As Variant Categories = Array("S50-1", "S50-2", "S35-1", "S35-2") For Each Category In Categories If strModel Like DLookup("[PN_Identifier]"...

Hey I am fairly sure I gave you everything. What are you missing?

Haha nice. Well thank you for chiming in I appreciate it.

Hey Mark, I have [PN_AC_Category] and [PN_Identifier] in the same table.. We're just trying to figure out now how to improve the performance by still having the user access to adjust the wildcards in the table that pop out that rates in the query. I believe prog will provide some help through...

@plog Attached I have provided what you requested: Table A is the Rate table and B are the results that i want to achieve. Thank you again as I am always interested in improving. I also took the array advice and this did seem to improve the query a little bit. Code below: Function...

@Minty thank you for the advice. I am an average SQL user. How would I go about doing the join to that table I posted above without using the If statement? I need to do the join based on the wildcard column in the table and pull the rate. (I think plog is going to answer as well)

@Plog I have tried the SQL approach and due to the amount of wildcards I get the "too complex". How would I code this in SQL so I don't get this error? Can I do it without if statements?

@plog wow thank you.... I heard about arrays but didn't really know how to use them. Let me give this a shot. I'll post code here if I succeed or have issues.