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: *

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

    Query Based Form: How do I ignore blank records?

    I created a Maintenance FORM, that allows users to update and correct data they already added to the data base. I did this by creating a simple query, and then creating a form off that query. How can I get the Maintenance Form to show only records that have data in certain (relevant) fields of...
  2. DesertTrip

    Group by process (Scriver? Anyone?)

    Scriver was extremely patient last month and taught me alot about grouping like records from one field of a query. I did great on my own for the next 5 queries that required this action. But now, I am stumped with my latest one. It keeps telling me that I am having a Syntax error and when I...
  3. DesertTrip

    group/total records in a field with matching data?

    I tried this in Reports and I'm still looking for an answer. Someone at work suggested I try the SQL/query forum. So - Is there a SQL code that can identify and group/total all individual records that have matching data in one of the fields? Maybe a simple expression? In my Query, there is...
  4. DesertTrip

    Grouping & Summing identical fields in a report

    I am not sure if this should be in reports or in queries. But, I am suspecting I can fix this on the report level so I will give it a shot here. I am building a employee productivity report that includes data from query field that is a lookup table/drop menu. This lookuptable/drop menu offers...
  5. DesertTrip

    How do I ignore null fields in my report? Query?

    I have a query that includes an field of multiple choice/optional entries (from a look-up table). Let's say (for example) that this particular field is "TypeOfPets". I need to make a Report that will use ONLY the records that have information entered in "TypeOfPets". If...
  6. DesertTrip

    Days Between Dates 4 beginners please?

    I am new at Access so I need any suggestions typed out for a beginner. In my design query, I have a column for BeginingDate and a column for DateDone. I need to count the days between these two entries. I researched everywhere and found this: Syntax: NumDays = days365(StartDate...
  7. DesertTrip

    "#Name" shows in a form field

    I am just learning Access for a project I was assigned. Boss thought that with all my Excel skills, I should be able to figure out Access quickly. HA! (My head hurts everytime I am within 10 feet of it) Situation: Using an input form, a user can make an entry that does update the table...

Part and Inventory Search

Back
Top