Recent content by sgladie@bgsu.edu

I figured it out! I had to concatenate the wildcards! This is what was screwing me up, thinking it was harder than it was. It wouldn't work properly until I did this: Like "*" & [tblNegative]![NegWord] & "*" And Like "*" & [tblPositive]![PosWord] & "*" All is well now. I knew I was making...

So here is the SQL: SELECT tblTargetText.TargetText FROM tblNegative INNER JOIN (tblPositive INNER JOIN tblTargetText ON tblPositive.PosWord = tblTargetText.TargetText) ON tblNegative.NegWord = tblTargetText.TargetText; I joined the tblPositive table and tblNegative table to TargetText field -...

Hello, Access 2016 Three tables: tblPositive (has one field PosWord) tblNegative (has one field NegWord) tblTargetText (has three fields: Chapter, Paragraph, TargetText) Goal: I would like to have a query look for all the PosWord in TargetText and return those records. I have tried...

It is not an assignment, I am helping a friend out. Basically just want whatever value they select from the combobox - which recordsource is from Table 1, field "word"... I want the listbox - recordsource Table 2, field "text" to search through Table 2 and return all records that contains that...

Hello, I am working with two tables in Access 2016. Table 1: has only one field, called "word" (no primary key) Table 2: has three fields, one is auto pk, another called "chapter" and a memo field called "text". I am trying to create a query/form that takes Table 1 "word" value and looks...

Hello, I recently updated my subscription for Office 365. Access 2013 to Access 2016. I have a fully functional database I am working on. When it updated my Access, I went about working in the database as usual. I did not Save As to 2016, it just saved as normal. My problem: It lost all my...

TecnicoAlpha I am not sure, but it sounds like you "inherited" this database and the forms and other objects were already setup, am I correct in that assumption? It also sounds like you are trying to "rush" and create something on the fly. I cannot stress enough the importance of having...

After I replied to both of you, I sat back and thought more about this. And yes, you are right, I need to use the other calculation I created for TotalTurns. I am sorry if I wasted anyone's time. THank you!

Minty - if I do the <> Occupied, it will remove the calculation I need - the TotalDays value 13. Plog - same thing goes if I just ask for In Renovation and/or Ready to Rent, then I will receive the In Renovation TotalDays value 186 - which is really the days it was in Occupied status. I...

How are your relationships created!? Do you have your primary and foreign keys setup properly!? With 80 tables - that would be the first place I would start. Do you have tables with redundant information? A successful Access database always begins with the tables and relationships - once you...

Access 2013 I am trying to create a query that will provide the turn over status of a unit. There are four statuses a unit can be in: Occupied, Ready to Rent, In Renovation, Out of Service. My setup query's data is: 7249 Occupied 9/1/2015 8/19/2015 13 7249 Ready to Rent...

I got it - thank you so much!! I can't figure out how to mark these threads SOLVED though.

I believe integer is appropriate. The values are whole numbers (negative and positive), no decimals. It is actually days. For example: TextOverUnder = DaysinStatus - TextAvg If TextOverUnder is over the TextAvg then I want the font red.

Access 2013 I am trying to format a field within a report. I have the event on the On Format of Detail. Two fields, if one is greater than the other, make the font red, if not, black. Here is my code: Dim ct As Integer Dim tc As Integer ct = Me.TextOverUnder tc = Me.TextAvg If ct > tc...

That's the other problem - I can't find the code that I originally used to turn it off and turn back on. It was actually from this forum. But now I can't locate it. There was code to turn it off and on. I put the turn off code when the form opened, and the turn back on again code when the form...