Search results

I wanted to add quickly that this is my criteria for the 3 diff traffic light graphics: redlight bmp [Calcs]![Change from basline] >=0.05 yellowlight bmp [Calcs]![Change from basline] <=-0.05 greenlight bmp [Calcs]![Change from basline] between -0.05 and 0.05 "Calcs" is the query based on...

okay: Use this format data_tbl Server_Type, Item, Device_Count, Billing_Date End User, EPIC Standard Thin Client Desktops, 1755, Dec-12 Intel Based, Medium 22...

You are correct. Those are the 2 issues. data_tbl contains all records. [Server_Type], [Item], [Device_Count], [Billing_Date] I have another table "baseline_tbl" That contains the same fields with a few differences. The [Device_Count] in the baseline tbl contains the target number in it. the...

Hi, I have a query that returns a all records (there are 91) that meet a criteria. From this query I have built another query that groups these results by two fields [Server_Type] and [Item] and then I add the [Item] field again and add Count in the total row. Lastly, I have an OLE object that...

Brian, I appreciate all you effort. I used your code and while it does work now if i choose from the drop down, it returns all records when using the keyword search. I think I'll take your first suggestion and add an extra button to a second query. again, many thanks. Robin

okay Brian, Give this a try...

Brian, Thank you for your quick response! I used some of your code from your posting. That is what gave me results for a keyword search (thank you). But I can't get both the dropdown and keyword search. If I make a selection from a combo box the criteria is ignored and all records are...

I have a select query that runs nicely based on the criteria chosen on a form. My problem is that I have 4 combo boxes as criteria and on textbox (used as keyword search) and I can only get the query to return records for either any of the combo boxes or just the text box. I have [Forms]![name...

As a follow up, I found a work around for this problem. I did a make table query and used that table as the records source for the sub report. Much faster.

I have read many posts on this subject but I can't seem to get anything to work. I have a main report based on a query and then a subreport based on a different query. the parent/child fields are txtReqUNID and ReqUNID. Sorted and criteria fields are indexed. I've removed the "order by" sql...

I'm not grasping where to put this code. If its in the on change event of the combo I would need to reference the child field on the subform [assignee], that is linked to the parent field/combo box on the main form cboassignee I would think.

I looked at the other postings for adding "all" as a choice in a combo box on a form and I have successfully added this choice to the combo box. My problem is how to return records for the all selection. The combo box is in the detail section of the main form "DataEntry" and is used to...

I realize this is an old post but I am working in access 2010, but any answers that work for 2007 would be great. I have a simple query using one table and I am using the BETWEEN AND criteria. It just returns random dates no matter what. Here is the SQL: SELECT IIf([Join_tbl]![TaskAssignee]...

I have refined the code to look like this: INSERT INTO Join_tbl ( ReqUNID, TaskTeam, TaskAssignee, taskStatus ) SELECT dbo_vwAssignments.ReqUNID, dbo_vwAssignments.TaskTeam, dbo_vwAssignments.TaskAssignee, dbo_vwAssignments.taskStatus FROM dbo_vwAssignments WHERE...

Hi, I need to run an append query (or do insert into sql) for records that are updated frequently. I have want to insert a new record if the ReqUNID exists but the taskStatus has changed OR if the ReqUNID does not currently exists. This is my current SQL: INSERT INTO Join_tbl ( ReqUNID...

I have a query in which I need to get the number of periods between and including the start date and end date for a project to use in a calculation. There are 13 periods in a year. I can't use exact dates for the periods because they change each year. The period is a field in a table and is...

I am using Access 2007. I have an append query that adds a new class to a table named Class_catalog when the Save cmd button is clicked. I have now decided I need to make a field in this table a multi-valued field. The field is named Job_title. I have a form Class_New that lets you make...

okay, I changed my final query to the format you listed vbaInet. It groups nicely now, however, in the text boxes for beginning and end dates on my selection form, if you enter a begin date of 1/1/2011 and end date of with this format: 8/1/11 the query returns 2/12, 2/12, 4/12, 5/12, 6/12...

Another place to check is in the row source on any forms associated with the report. Since this is an area where you create a query on the fly by do not need to give it a name, this could be a source of what is requesting input.

I would try entering all your criteria on the criteria line instead of on the OR line. This way the query will automatically write the correct SQL statement to ensure the OR Is Null criteria applies in every combination of choices made on your form. An example from a query of mine is: in...