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 bkrike 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: Dixen
  • Content: Threads
  • Order by date
  1. Dixen

    Can you force a record to display?

    I use several complicated Queries in my database. Some of my queries may not display all avail records that meet a given criteria because of "incomeplete" or missing data. Is there a way to force these records to show up in a query anyway? i.e. I have Status, Member Name and...
  2. Dixen

    Using Queries in Queries

    I have a query that is counting the number of times a member's name appears as 'Recruiter' called "Recruiting". I then use that query inside another query ("Membership") that my final membership report is based off of. When I run "Recruiting" it works flawlessly...
  3. Dixen

    Merging Two tables in a DB

    Believe it or not this is something I have just never needed to do. A database was set up with two seperate tables relating on a Name field. How does one merge the two tables together without loss of data?
  4. Dixen

    Need Help useing IF Functions in Queries

    I have a field that I want to calulate a number of points off of based on the value. Basicly if the starting value is between 21 and 31 assign a code of 1, if between 31 and 41 assign a value of 2, etc... However, when I write the IF statement in the query design view I get an "undefined...

Part and Inventory Search

Back
Top