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 derfloh 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. MooseMan

    MDW Problem

    I have the strangest problem with an Access database that is secured. We have three user groups defined with specific rights to which we add individual users. In one specific case a single user needs access to a form that no one else in his group needs. To accomplish this I simply gave him...
  2. MooseMan

    Calculated Control

    I have a calculated control which calculates a value based on two textboxes and two Listboxes on the same form. The two list boxes get there data based on underlying queries. The problem is that the calculation does not perform accurately. This is my code...
  3. MooseMan

    Missing Records in Query

    Your right Rudy I get missing Data. this is all fairly new to me could you be a little more specific as to how I create a left outer join and substitute o's. I really appreciate your help Bruce
  4. MooseMan

    Missing Records in Query

    I have two tables tblDefault and tblDefaultDetails. I have one and only one record for each producer in tblDefault that records the original Default amount at the end of each crop year. In tblDefaultDetails I have a monthly report for each administrator recording the amount repaid from the...
  5. MooseMan

    Set Default Value 0.00

    Thnaks for replying, Could you elaborate on how to use If IsNull as an expression in a query or a control source
  6. MooseMan

    Set Default Value 0.00

    I have a report that I need to set the default value of a textbox to 0.00 but have had no luck doing it. If no value is returned I just get a blank. I have tried the If Isnull in the format event. Microsoft help also says there is a default value property for the textbox on the report but I...
  7. MooseMan

    No Read Definition

    The back-end which resides on a server is compacted each night. Would that have any adverse effects?
  8. MooseMan

    No Read Definition

    I have a number of queries called from a function that creates a temporary table and then populates and runs calculations on the data. My problem is that after everything working for a number of weeks, the function began to freeze. I discovered after attempting to run each query individually...
  9. MooseMan

    I have a form which has an unbound

    I have a form which has an unbound list box which displays the total advances made by a producer. A command button from that form opens a frmNewAdvance form (leaving the first form open) which allows data entry. One of the fields on the frmNewAdvance is txttotalAdvances. What I need to do is...
  10. MooseMan

    Finding Distinct Records

    I need what should be a simple query but never the less does not seem to wan to work for me. I have a table called tblClaims which records claims paid against producers. Each producer could have up to three(3) claims per crop year. One for interest, one for legal, and one for principal. what I...
  11. MooseMan

    Query Based on Last Date

    I have a table called tblDefaults which contains monthly default reports for 50 different administrators. I have been trying to build a query based on three fields in that table. AdministratorID, DefaultAmount, and ReportingMonth. My problem is that the query which will show the default amount...
  12. MooseMan

    Basic Query Question

    Terry, Thank you so very much for all of your help it is very much appreciated.
  13. MooseMan

    Basic Query Question

    SELECT DISTINCT c1.[Last Name], c1.[First Name], c1.Address, c1.City, c1.[Province/State], c1.[Postal Code ] AS Expr1 FROM (Campers AS c1 LEFT JOIN [Select c4.[Camper ID] From Camp_Campers c4 Where (c4.[Camp ID]="DC102" Or c4.[Camp ID]="DC202")]. AS c3 ON c1.[Camper ID]...
  14. MooseMan

    Basic Query Question

    Terry, Orginally I thought that placing Distinct after the first select was the answer, but when I do that I get an error saying there is a syntax error in the from clause. The query works fine apart from adding "distinct" Any thoughts?
  15. MooseMan

    Basic Query Question

    Thank you very much Terry for all your help. Everything worked great. I have one more small question. I have duplicate query results if campers have attended both previous camps. How do I suppress duplicates. When I added the key word "DISTINCT" I was given an error by Access...
  16. MooseMan

    Basic Query Question

    Thanks for responding with the examples. I am just getting my head around these select statements.I am going to impose and ask you to be even more specific. We have two tables tblCampers and tblCampCampers. There is a one to many relationship between the two based on the CamperID. CamperID...
  17. MooseMan

    Basic Query Question

    I have two tables one with camper names and one with the camps they attend. There is a one to many relationship between the two. I want a basic query that selects all campers registered in either "DC101" or "DC201" but who are not already registered in "DC102" or...
  18. MooseMan

    Error when Data Missing

    Thanks John with your suggestion I was able to ammend the join type to solve the problem Thanks again
  19. MooseMan

    Error when Data Missing

    Thank you very much for responding. I am fairly new to all of this so could you be rather explicit as to how I go about creating that "outer join" Thnaks again
  20. MooseMan

    Error when Data Missing

    I have a Financial Summary Report which is built on a query that draws from three tables and two other queries. One query calculates totals of amounts paid by administrator, and the other calculates Interest Totals owing for each Administrator. My problem is that when I run the report for...

Part and Inventory Search

Back
Top