Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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]...

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?

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

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

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

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

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

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