Search results

  1. T

    query using 1 table vs 2 tables

    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...
  2. T

    Query is duplicating data

    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]...
  3. T

    Hardcoding in Field Name in Query Design View

    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???
  4. T

    Hi from GA - USA!

    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...
Back
Top Bottom