Search results

I think this is an easy one and my brain just isn't working yet. I have 2 queries. In the first query I have a table with DEPT field and one of the query fields says the following: New Account: GetElement([DEPT],1,"*") which is telling it to give me the value in the DEPT field that is in front...

Thanks The Doc Man!!!! You are THE MAN!!! Turns out I was on the same track as you as far as deleting those fields that were not immediately neccessary. I had the thought of incorporating the MAX function but was stuck on when and where to use it. Then I read your post!!! Ding Ding Ding Ding...

Thank you spikepl, plog, and jdraw for responding. My very first post I was advised to show the code for my query and then ask the question. It was a simple query and question. So this time I showed the code and it is too complex and unwieldly. I think I am finding a happy median now. I...

UGH!!! Ok, I created a query using 2 tables, [tbl_transaction_details_b] and [Siemens_Contact_Info1]. Currently it is pulling 38 records (which is right and the same number of records in tbl_transaction_details_b). But when I add Line Number to the query (which is in [Siemens_Contact_Info1]...

YAY! Thank you! I knew it was a simple answer. I truly appreciate you sticking with me until I got this thing figered out. You are awesome!

Yes! They are, but I need that actual wording hardcoded in the column. I eventually export it to an Excel file and need that formula in order to complete the process in Excel.

I hope this helps: The issue is this part of SQL TEXT(ROW([A17]),"-0") AS [IDENTITY], SELECT tbl_transaction_details_b.SHIPTOCUSTOMERNAME, tbl_transaction_details_b.SHIPTOADDR1, tbl_transaction_details_b.SHIPTOCITY, tbl_transaction_details_b.SHIPTOSTATE...

Hi, Simple question: I am trying to hardcode in the field name. This is what I want to hardcode "TEXT(ROW(A17),"-0")" but the parenthesis and quotation marks are causing a syntax error. It appears like this IDENTITY:"TEXT(ROW(A17),"-0")" What am I doing wrong???

Hi Paul! Yes, quite different. Before Access my primary duties were 100% in Excel. Now, Access is and about 30% Excel. It is difficult making that transition back and forth on a daily basis. Not to mention I support a team and have to be well versed in both. I love a challenge! Thanks...

Call me Tiff, I know basic Access and have had some college classes on Access in the 90's. I have recently been tasked with maintaining multiple Access databases at my company. I have taken it over due to downsizing and am the only "knowledgeable" one to handle it #OMG, #SCARY! However, I...