Recent content by raydan

Well im getting results for this year. 2 records returned. 3/8/2006 and 4/10/2006. There are several others from 2005 that it should be returning, but the query is omitting an year but the current one.

In my DB im trying to determine the aniversary date of a loan closing. I can't seem to get the query to ignore the year and just show me the loans that closed in upcoming month regardless of what year. This is what I have so far, what else do I need. thanks, Raydan SELECT Loans.LoanID...

Hi all, I created a database for my company and it works very well but, I need it or something to track the way I pay comisions. Its a type of multi-level company and pay rates vary. Also, once someone hits the top level they now join in profit sharing. The profit sharing part is the tough...

Hi, all. Im trying to show multi level organization with a query and im not sure how to do it. I have a table that is named Originators, that includes all of the persons personal info and this table gererates a OriginatorID. Next I have a table called OrgTree that has the fields as follows...

Well im close to putting my DB into action, but I'd like to have a form that will show a list of queries and reports where they can be selected and emailed. I would like to be able to choose one or many files. I have created the email module and its working fine, I just thought I could make it...

Wow, there is this beautiful tab called lookup. I used that and guess what it worked, thanks for the help. But before i call this done, will what i just did work because I didn't have to join anything in the relationship window. I'm concerened that this won't work. Now it looks like this...

Ok, this makes sense to me but i'm having trouble implementing the idea. I added the line UpLineOrig to that table. I save it then, open relationship table and I join the OriginatorID to UpLineOrig. Is this what im suposed to do because the results aren't correct. I get a sub-table that...

I have a DB thats working fine, but (there always is a but) I now need to do something a little bit different. I need to be able to track my originators and who they have brought into the company. So I will have an originator and many down-line originators, and these people that come in...

open the relationships sceen and right click on the connecting line between the 2 tables. Clk edit relationship and when box appears choose join types. There you can select the type of relationship,where the 2nd and 3rd choices are 1-to-many. Good luck.

SELECT Commissions.OriginatorID, Sum(Commissions.AmountPaid) AS SumOfAmountPaid FROM Commissions WHERE (((Commissions.DatePaid)>DateAdd("d",-32,Date()))) GROUP BY Commissions.OriginatorID; This worked for me. Now I get on total for all originators. Thanks for all the help. The "...

TransactionID OriginatorID SumOfAmountPaid 40-0007 101-10005 $78.00 40-0008 101-10003 $600.00 40-0009 101-10001 $500.00 40-0010 101-10001 $2,010.00 This is what im returning when i use: SELECT...

Actually its still not totaling the amounts. Now im lost.

Well, just found the totals button. So I actually helped myself. :p

SELECT Commissions.TransactionID, Commissions.OriginatorID, Commissions.AmountPaid, Commissions.DatePaid FROM Commissions WHERE ((Commissions.DatePaid)> DateAdd("d", -32, Date())); I want to add up commissions paid in a month using a simple query and im not sure how to proceed from here. This...

WHERE (((Loans.StartDate)>DateAdd("d",-32,Date()) And ((Loans.EndDate)>DateAdd("yyyy",-1,Date())))); I pasted this in and now I get 0 records in the query.