Search results

Wayne, can you explain a little more, pass the PK, not sure, can I send you the database and vba modules I already have and you give me a little more guidance.

104 views and only one person comments, please forum, help a fellow accessite out :)

Can anyone else chime in, i can send you a copy of my de-sensitzed database.

Rokhi, please check your pm.

I think I could use those codes, but I am not summing all the AKW and NAKW values. I am only summing those that have the same ending number together, NEWAKW11=AKW11+NAKW11, NEWAKW12=AKW12+NAKW12, etc... (ie AKW11+NAKW11, AKW12+NAKW12, etc...) However this is not all my vba code do, here is...

I cant seem to open that file i am running access 07 and its giving me issues. What I tried to do was create another query that summed up the akw and nakw values, (this was part of the case function in vba). The new query is called qAkwSum, and the fields created are...

Expression Too Complex - Passing 29 Parameters - (See Post#15 for Database File) I trying to pass the parameters below into a VBA Case statement, but I am getting a too complex error, I have spent all day sorting this out and this is the last step, any ideas how I can get access to take this...

i figured it out

Ok I rewrote it as a case statement in vba, can anyone help me verify this code will work in access and how to implement it into the query Sub FirstQtrRevMth1to12() Dim dCurrentDate As Date Dim sDate As String dCurrentDate = [MNTH1] sDate = Month([MNTH1]) & "/1/" &...

I am trying this really long query expression to get quarterly data, but I run into a 1024 character limit error, can anyone help me with a work around 1ST QTR ENERGY MONTH 1-12: IIF ([MNTH1] LIKE "1/1/" & Year([MNTH1]), [AKW1]+[NAKW1],IIF ([MNTH1] LIKE "2/1/" & Year([MNTH1]),[AKW2]+[AKW1]...

nevermind i got it, had to first name column "Subtotal" and sum each column, example: Field:Subtotal:[col2]+[col3]...+[col5] Then select Group By Thanks drake for pointing me in the right direction.

I am not sure how to do the DCrake. I selected Group By for column 1 (Cust Name) I selected Sum in column 2-5 I am not sure how to setup the sum column...

Any help, or should i just bring the raw data over into excel and process it there?

I have search around the forums and have only been able to find a partial answer to my problem. I have a table with say 5 columns. Column1=Business Name Column2=DebitMonth1 Column3=DebitMonth2 Column4=DebitMonth3 Column5=DebitMonth4 Column1 will have different business names, but it will also...

Thanks Mike that was really helpful in explaining how the wildcard feature worked. It has given my a far better understanding. I was actually able to use Rockyjr's code and it does what I need. I need help with another query that only shows each variation once. I have created another...

Can you give me more guided steps on this Mike or anyone, I am new to all of this...

Awesome Mike thanks for your reply. The next step is before it actually runs the query, I would like it to be a 2 step process. I would like all variations of the name to be shown in a listbox on the form. The user will next select all variations to by clicking on each one, if multiple, press...

Thanks Rocky, I think I am doing something wrong. Here is my setup: Form where user enters customer name: Form Name: Cus_Input Textbox Name: Cust_Name Output variations of customer name into listbox name: Cust_Out Table Name: TableCustomer Customer Name Field in Table: CustomerName I have a...

I am new to access and have a question on how/if this can be done. I want to select companies from a large table >50,000 entries. The user will enter in a name, say 7-eleven. This may be entered in the table with different variations say 7eleven, 7 eleven, 7-eleven, etc... I would like for...