Search results for query: *

I am trying to use the Indirect function to handle the formula below (not my actual formula, but a simplified version): =IF(F10=0, "Correct", "Incorrect") When I type in the following formula to use the indirect function I get a #Value error: =Indirect("=IF(F10=0, " & """" & "Correct" & """"...

This one works every way I try to open it. Thanks again, PHV. Also, thanks to lameid and sxschech for helping me try to resolve this issue. Marrow

The name of the query does not start with "Select" and does not have "Select" in the name. I even copied the SQL and moved it to a new query, but the results are the same. Here are the 3 queries that I made that give me the same results: qryZZZCalculation-NewForecast#1 SELECT...

Taking out the semicolon did not produce any differences. My original post on this topic was located below. This shoud show you the tables I am trying to combine and what I am trying to do with this subquery: http://www.tek-tips.com/viewthread.cfm?qid=1642580&page=1 Perhaps there is a better...

Thank you for your help, but even with your updated SQL I am still having the same issues. Here is exactly what is happening: 1. When I am in design view or SQL view and run/open the query it comes up with no problems. 2. When I am at the query listing in access and run the query or...

Below is a query that I put in the SQL view and appears to work perfectly when I view it in design view then open it. If I try to open it directly or reference it in another query it does not work. Any ideas? SELECT F.Project_Number FROM tblSpending AS F LEFT JOIN [SELECT Project_Number FROM...

Works perfectly. I added a "Group By" piece at the end and got to my answer. Thank you for your quick response, PHV. Marrow

I just read about subqueries and I think I am closer to my solution. I need to be able to combine these three queries into one query (if it is possible): Query #1 not used. Query #2 SELECT tblSpending.Project_Number FROM tblSpending WHERE (((tblSpending.Spending_Type)="forecast - previous...

I was seeing if there was an easy way to write a single query to compare records within a table to find ones with different values. As an example, I have a table with two fields (it has more, but this will simplify things): Project Name and Spending Type. Neither is a primary key. To...

I have a query based off a crosstab query and every month, another month gets added to the crosstab query. I am trying to force the secondary query to always pick all the fields from the crosstab query based on the name of the field. I only want to show the fields that begin with "2010" (this...

I am moving an excel spreadsheet over from Excel 2000 to Excel 2007 and I am having a problem with my Macro Buttons. In Excel 2000, I had multiple buttons on the button toolbar to help the users move from one tab to another (users are not very proficient with Excel and do not use the...

I think I am finally there. I went a bit over budget, but I got the wife to buy into the idea. I took wahnula's advice and got the larger HDD and better CPU. My only concern now is the heatsink/fan. If the stock heatsink/fan will work for a few months of non-overclocked usage, I should be...

Wahnula, I have taken your advice on the HDD, heatsink/fan, and card reader (no floppy, because I just got my whole family to give them up and go with USB keys). Also, based on your recommendation, I changed back to my original CPU. I appreciate your advice on the new CPU, but I think that...

Thanks for all the help so far from everyone. Ok, I have made some adjustments to my original build. Here is what I have now: https://secure.newegg.com/WishList/PublicWishDetail.aspx?WishListNumber=5064109&WishListTitle=Updated 2008 Computer 1. MB - ABIT IP35 Pro LGA 775 Intel P35 ATX Intel...

Thanks to everyone who has offered suggestions. Based on kmcferrin's suggestions, I was able to save an additional $125 and it sounds like it will improve my current system design. Questions on the SATA vs ATA: 1. What is the difference? 2. I am use to setting up ATA Hard Drives, so is SATA...

Ok, I made some modifications based on your recomendations. I have replaced the 800 RAM with 1066 RAM and I switched one of the dvd burners to a dvd reader (although I may just change it back because it is only saving me $8). As for the power supply, unless it will be a major problem, I may...

I am in the process of building a new computer and I need some advice. My goal is to build a solid system for around $1,200 that will run Vista and will enable me to run MS Office and games (FPS and MMORPGs). I am looking to start from scratch and based on some articles that I have read, I...

A colleague has developed the following code, but I wanted to adapt it to pull a little different information. I wanted to be able to input a directory name (instead of the user group) and get all the users who have access to that directory. An additional plus would be to also select the type...

I have a table that I would like in another format and I believe that it can be done with a query, I just dont know how to do it. Here is the information that I have: UniqueID ObjectName1 ObjectName2 ObjectName3 1 ABC ATR BPI 2...

Perhaps you should check the textbox's value before you do the > 0 check. I would suggest the following: If Me!txtRVID = "" then msgbox "Please place a value before you continue", vbokonly exit sub end if If Me!txtRVID = "" does not work, try isnull(Me!txtRVID)...