Search results for query: *

It looks great! Thanks so much Duane.

You are correct. I meant to say reports not forms. Thanks for your help. It works perfectly. One last question. Is it possible that the dates can be shown on the report? I tried to put a couple of text boxes on the report for the dates, but they did not appear. Just wondering.

I am sorry for the late reply as I was out of town without my laptop. I had removed the date that was originally there but have again put it in. From this single query I have one chart for Line of Business and another chart for Reason. Since both use the date field from this single query, the...

I am wondering if it is possible to have 2 charts made from the same query on one Report page (no record source for the blank report where sub report charts added) where a date parameter can be entered once and cover both charts. I tried a few basic things, including attaching the main report...

I may or may not be using the correct event so that is why I need to ask my question. My combo box is based on the selection of a department name from the tbldepartment.Once selected, the after update event will filter the data and open the correct report from table1, field department...

Sorry for the late thanks but just got back from holiday visit and didn't have my computer with me. Your help gave me what I was looking for and I do appreciate your good advice as well. Its an easy concept to remember and I will do that.

I have been trying to figure out how to combine criteria/expression without creating another query. I was wondering if this can be done. I need to see all records (open and closed) for the current and previous year as well as records for other years that are null in the Date Closed field. I...

Having a problem with my sort order, which is probably something very simple that I am not seeing. The query works great but the report is a bit of a problem. In the case of Duplicate names that have a Jr. and Sr. following them in the last name field, it is grouping everything under one of...

I have created 2 separate Chart reports from a single query and did not show any date parameters. I placed them both on a report that is not bound to a query. I have been looking on the internet and have tried a several different things, but they are not working. The following link gives...

Perfect! I don't know why I make things so complex! I changed to integers on the table and it works grand. I kept changing the table from numbers to text to date and back and forth as I was using different samples, so when I came upon this function set up, I had changed back to text. Thanks...

I have looked at tons of info on the year and month functions and get more mixed up as I look. What I actually had thought about also is using the same technique that I used for my working text box and forget the after update. Following are a couple of the functions I have for Month and Year...

When the form is opened, the current Short date automatically populates so the user does not have to make the entry. On a second form that is used to pull reports, I have combo boxes for CSR, Year, Month, and Team, which are all fields on the query that make up some of my reports. I want my...

I am fairly new at working with functions and controls and I have looked at so many samples and references, including tec tips,but I cannot seem to make anything work. I have 3 unbound text boxes. One is for current date:date()formatted as short date and it works perfectly. I then have a...

Sorry for the late response back but been out of town and just got back. Thanks for your advise, and I did again check several more posts and I am all set now. sometimes I check so many posts or references, that I confuse myself more. Thanks again.

I am fairly new at this and have reached a bump in the road. Below is the SQL for a query I have made. What I would like to do is update one date field (complainceDt) when the service date is greater. I have no clue how to do this and would appreciate it if someone could give me some advice...

I am new to Union Queries and struggling with how to format one that combines about 6 different queries with duplicate field names and contains parameters. I am hoping someone can assist so I can learn better how to do these. Below are are the SQL's for 2 of the 6 queries so you can see how...

CK1999, The form I am using is frm_Results and the query that builds the report is qryClientServices. I tried what you indicated and I get the error, "You cancelled the previous operation". I still could not get the step through to work, which makes me feel a bit like an idiot but I will...

thanks for your responses. OK, now I really have to admit that I am still a newbie at all this and unfortunately there are certain things I copy without a full understanding of some of the terms. For example, when KenReay asks, "are both EmpId and stWho strings?", I am not exactly sure how to...

Trying to email a report from a form - based on a query that contains EmpID, Name, Email Address. I continue to get the error: "Data Type Mismatch in Criteria Expression". I am using the same format that I have used on other DB programs successfully except that this only has the EmpID to use...