Search results for query: *

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

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

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

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

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