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 Wanet Telecoms Ltd 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: *

  1. coyote1x

    Need help with a unique customer id

    I am creating a database that will hold customer information and order information. I want to create a unique customer id using the first 3 letters of the last name and the last 3 letters of the first name. Can this be done if so how? Any help would be great. JJ
  2. coyote1x

    Need Help with an error

    I am receiving an error message when trying to open my database. Does anyone know how to fix this. 'AOIndex' is not an index in this table.
  3. coyote1x

    Run time error on a form

    All I have created an edit records query and an edit anwser query so people can edit answers to various questions once they have been entered. I have created 2 forms and the associate opens the Edit Answer form by clicking on a command button. This works great. However when they changes they...
  4. coyote1x

    Query Help Needed

    I have built several queries to count the number time yes is checked for a line item. When I run the individual query it works perfectly. I want a report of the combined queries. When I combined the queries the data no longer displays. Can someone please help me figure this out. Below is...
  5. coyote1x

    Building an expression in a Query

    Thanks PHV it is working perfectly now.
  6. coyote1x

    Building an expression in a Query

    Ok I have tried both ways and now it is asking for a paramater. If I click ok past the paramater it calculates correctly. How do I remove the paramater. Here is the SQL. SELECT tblSupervisor.SupervisorName, Count(tblAssociate.AssociateID) AS CountOfAssociateID, [CountOfAssociateID]*10 AS...
  7. coyote1x

    Building an expression in a Query

    I have built a query that counts the number of Associates that are under a supervisor. The query works great but I want to build an expression to take the total number of associates and multiply them by 10. Does anyone know how to accomplish this. Any help you can provide would be great.

Part and Inventory Search

Back
Top