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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by nanasandy

  1. nanasandy

    What am I doing wrong?

    That isn't what I wanted to hear obviously it keeps me from doing what I wanted to do, but thank you for setting me straight.
  2. nanasandy

    What am I doing wrong?

    Well, yes, but how can I get the number value for each thing? I still need to count how many have each item.
  3. nanasandy

    What am I doing wrong?

    Sorry after reviewing your question closer, the field type in Client file is number due to doing a field lookup to fill this field.
  4. nanasandy

    What am I doing wrong?

    Yes the Primary_Heating_Fuel type is text. I hope this is what you are asking for: SELECT Client.*, [~tempJobCompleted].*, County.County, Client![Last Name] & ", " & Client![First Name] AS EName, Not Client!Owner AS Renter, IIf([~tempJobCompleted]![Add On],0,1) AS [Jobs Completed]...
  5. nanasandy

    What am I doing wrong?

    Sorry, this is my first time. Honestly I'm not sure why this temp file is here other than it appears to give other criteria that has to be met before the counts on everything is done. I didn't write this DB only trying to modify it. This is one that works: OwnerSF Count: IIf(Client!Owner=True...
  6. nanasandy

    What am I doing wrong?

    I have a Client table with a field called Primary_Heating_Fuel. There are 7 different values that could be in this field. I need to count how many of each value there are and this is the first value I'm trying to count. I keep getting an error. The record needs to meet both values to get...
See more

Part and Inventory Search

Back
Top