Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jabenj
  • Content: Threads
  • Order by date
  1. jabenj

    Select Query with Sum formula from multiple tables

    Can someone please let me know why this isn't working? I'm trying to take the difference of two fields from two separate spreadsheets. I believe it's only reading from the first spreadsheet (tlbLatexBatch QC) and not the other. Any help would be greatly appreciated. Dim con As Object...
  2. jabenj

    Select statement, multiple tables

    Once again I'm stuck. Shocker. I'm trying to take data from multiple tables and Sum them. I think what I have should work, but I keep getting a runtime error 2465 saying the field "'" can't be found. Do I need to do a join statement? Help is appreciated. Thanks Dim con As Object Dim...
  3. jabenj

    Query most recent record

    Hi. Any help would be greatly appreciated. I'm trying to query my database for the most recent record for a tank specified by the user on a form. I have an If then statement based on that query as shown below: If DCount("LotNum", "[Blendsheet Input]", "TankNum ='" & Me.cmbTankNum & "'") =...
  4. jabenj

    Select Query with IF THen statement

    Hi All, What I'm trying to do seems simple enough yet I can't get it to work. I am querying a database and I want a text to display based on my IF Then statement. However, it seems as though my select query is only reading my most recent value in my table instead of the select values...
  5. jabenj

    Message based on select query

    Thanks in advance for any help. I'm trying to do something that should be simple enough but it's not working. I'm trying to display a text in a field based on a select query. If a value exists in a field in my database (LotNum in Blendsheet input), then i want my text box on a form to say...
  6. jabenj

    Formatting of query results

    Hi All. I made an INNER JOIN query that returns entries from two tables that are related by a common Lot#. So I want the query to record all entries, from two tables that are related to a Lot# that the user enters. I was able to do this, however, the query returns duplicate entries. It's...
  7. jabenj

    Updating empty field in access table with text

    Hi. I'm a novice trying to update a field (LotNum) in an access table (Product Input) using an update statement. I'm updating through a form that the user fills out under two conditions: 1. the LotNum field is empty, and 2. the appropriate tank is selected. First I was getting a Write...

Part and Inventory Search

Back
Top