Search results

QUERY I HAVE TRIED THAT TOO AND IT RETURNS HUNDREDS OF DUPLICATE RECORDS. ANYWAY TO AVOID THAT?

QUERY FORMULA THAT DIDN'T WORK EITHER. AS SOON AS I ADDED A RECORD FOR THAT MONTH WITH $0 CONTRACT PRICE, THEIR VALUES SHOWED UP. SO THE JOIN IS CAUSING A PROBLEM AND I DON'T KNOW HOW ELSE TO JOIN THEM. THANK YOU VERY MUCH THOUGH.

Ok. I am getting really frustrated with this. Let me try to explain the DB first. This is a contracting database. The user inputs all our contracts. Salesman Info, contract price, units, etc... tblContractInfo - holds all pertinent contract info. Date, price, salesid, units, builderid...

Nulls I am using the NZ() function. If you'll notice above, I posted the criteria I have in each of the query fields. It will not work for some reason. I have the correct join properties, I am using the NZ() function, I'm not sure what else to try!!!

Date Date is one of my column names. However, I followed your advice and changed it to InputDate. It still does not work. I can't quite figure it out. Access should be able to do this. I want to show all our salesman and then show if they have had any sales for the year. If there are no...

SQL SELECT tblSalesman.OfficeLocation, tblSalesman.SalesID, tblSalesman.SalesmanName, tblSalesman.Current, Sum(nz([Total$],0)) AS Total, nz(DatePart("yyyy",[Date]),0) AS Years, nz(DatePart("m",[Date]),0) AS Months FROM tblSalesman LEFT JOIN tblContractInfo ON tblSalesman.SalesID =...

Relationship I have the join properties set as below: Include ALL records from tblSalesman and only those records from tblContractInfo where the joined fields are equal. The SQL view is : FROM tblSalesman LEFT JOIN tblContractInfo ON tblSalesman.SalesID = tblContractInfo.SalesID

I have a report that I am trying to create that will shows sales each month during the year. I have Months: DatePart("m",[Date]) in my queries, show they will show 1, 2, 3 etc.. as each month goes along. How can I add the future months into my report. If I add 4 it tells me it doesn't...

I am having an issue with one of my queries I'm hoping someone can help me with. I have a query that I need to calculate the $ amount of sales per Salesman for the year. However, it is not pulling up the salesmen with no sales. I have two tables. tblSalesman and tblContractInfo...

I have query based on two tables. Table 1 has the main ticket information TicketNo, Date, Type, EnteredBy, etc... Table 2 has the ticket detail TicketNo, Desc, Code, Amount, etc... What I am trying to do is count the number of tickets for each code in the...

New Input Query Basically, all our job information is kept in tblDeliveryInfo. The user goes in and inputs new jobs as they come in. However, not all new jobs are new jobs, they are just another delivery to an old contract. When we get a contract we assign that subdivision a job code. We may...

Is there a way to input the date mmddyy without the slashes?

I have a Delivery Database. We input the job information and track it as it moves through the plant to customer delivery. Each job has a specific job code. However, sometimes we deliver products on a specific job over several deliveries. These deliveries are differentiated by a RUN letter. For...

I have a question. I have a database that is used to input and print tickets. We would like to allow the ticket to print once and every time after that add the word "REPRINT" to the ticket when it is printed again. I'm not sure how to do this. Any ideas??? Thanks Brandy

I've been looking all over the forum for help on this. If I missed it, I apologize for repeating this question. I have a database that tracks tickets in our company. I have frmShortageTicket that is based on tblShortage that users input the ticket information on. We could have serveral tickets...

Horizontal Printing Ok, I am at a loss on how to do this. I would really appreciate any help I can get. I have been working on this for a few weeks now. I am attaching a small sample of the database. It has the tables, query, and report that goes along with this.

I am trying to create a Weekly Schedule Report. The query request a specific time period (Between [Enter Starting Date:] and [Enter Ending Date:]) and then displays the lots due to be delivered each day between the time period. The problem is that it would work better for me if I could get the...