Search results for query: *

Thank you all for your help. The formula is working great!!!

rdodge Thanks...that was what I was looking for. One problem is that when you change the date the data does not stay where it is. It is removed and the new value is put in. I need the data to stay in the cell even after the date is changed. Is there a way to do that?

rdodge - That change now returns #REF. I sent you an email with a generic xls workbook. The values had to be changed though. Thank you so much for your patience. I really appreciate your help!

I apologize for the lack of clarity on this subject. I am very new and am not meaning to upset anyone or frustrate. I will only have one data sheet that will be replaced each day with new values. That is why the date will always be in G1 and will always be TODAY(). The data page will have...

Also, if I do =MATCH(Data!G1,GS!$K:$K,0)&":H65533" I get 18:L which is the correct row column combination. When I add the ,0 I get #REF.

Hi, If I enter =MATCH(B2&"-"&K2,INDIRECT("Data!H:H")) it returns the correct row of 22 on the Data page where the data exists. If I enter =MATCH(Data!G1,GS!$K:$K,0) then it returns 18 which is the correct row on the GS page I want the value returned to. Then when I add the...

bluedragon2 These are returning values now, but not the correct values. It appears to be pulling the numbers from the same worksheet in C4 for L4 and I have no idea where it is pulling the number for N4. I can't find that number on any worksheet. Can you explain what exactly the formula's...

Ok. Neither option works. I am lost completely as to what may be causing the errors. I tried the first suggestion from bluedragon2 and it returns an error #N/A. The second example from rdodge the first part =A2&"-"&B2 works. But when I put the info into L4 it returns #REF! and...

I apologize in advance. I am new to creating formulas in Excel and need some help. So here goes, if I have not included enough information please let me know. Here is a layout of my spread sheets. Data A B C D E F G GS Marketing 2 99.9 01-Jan GS Technical 10 95.2 GS GS...

Hi Everyone, I have an access Database where I have a form that I want to prepopulate an outlook email with the following information. I have a control button that I will click on that should open the emial with the following fields populated. To: Table - person Key - personid field -...

I have the following tables/Fields First_Time_Buyer(table) Fields User_Id Dollar_Loss Potential_loss Coupon_Seller (Table) Fields User_Id Total_Purch Num_Loss Dollar_Loss Dollar_Prevented Num_Prevented Fraud_Buyer (table) Fields User_Id Dollar_Loss I want to match any User_Id that is...

I used the code similar to: Private Sub Form_Timer() Dim TimeNow As String TimeNow = Str(Time) TimeBox.SetFocus TimeBox.Text = TimeNow If TimeBox.Text = "8:25 AM" Then DoCmd.RunMacro "RunTotalUpdates" End If Exit Sub It works great to run the macro once. I would like to...

Hi Everyone, Is there a way to run a query or macro from the data access page? I have tried to use a command button and it does not work. I have a macro that runs several queries to update a table with new data. I want that macro to run either on the data access page as a button or when...

Hi. I figured out what was the problem. I am linking the Bugs1 - Bugs4 from excel spreadsheets and excel was reading some rows as text data type and others as memo data type. I had to trick excel to reading all rows as memo. Now I added the SQL code to that and it works great. Thank you...

Ok. Now it is saying that the field is too small to accept the amount of data I attempted to add. Try inserting or pasting less data. I really appreciate your help! I am impressed with your knowledge.

I removed the ReasonForRejection from the union join and that one brings up all the data from the other fields perfectly. So I took the code you gave me above and that adds the description perfectly. I am not sure how to get the ReasonForRejection added to that.

Ok...after I did the union query we realized that the ReasonForRejection field is also memo. So do I need to modify the second statement?

Thank you for all your time. I really appreciate it. Unfortunately I really need to keep the description. If you think of anything please do let me know.

I followed your steps to create a union query and I get the following message. "Can not use memo, ole, or hyperlink object in field description in the select clause of a union query." My description field is memo in all tables. So does this mean that that field can not be a memo type?

That sounds like it will work, but is there a way to run those queries automatically so that when Bugs1, Bugs2, Bugs3, Bugs4 have new information the Table (from Make-Table) is automatically rebuilt? Also, on the union query does that have to be run each time the new information is added to the...