Search results

I am getting this information from a table from Excel that is linked to Access. I was told this is most likely the problem. Is this true? How do I go about correcting it? Scott

my fields are Dollars Auth: F15 Dollars Expended: F16 % Funds Expended: ([F16]/[F15]) and then i put >=.75 in criteria and get overflow message

yes, I get 487 results. Does it have anything to do with the fact I have my results already in the percent format?

Still does not work. No matter what I do, I get an overflow message when I try to run the query.

I have a percentage of funds expended category and am trying to get all the funds that are 75% expended or greater. I have been typing in the criteria section >=".75" and am getting an overflow message when i run the query. I have tried different variations of this like adding a percent sign...

Gotcha, very new at this but you guys have helped me greatly

<"D">"value to not show" I have typed that in and then run my query and get zero results. I do not want to show the values of "D" and "C" The ones I want to show, for the most part have nothing there. (they are not done or complete) So do i want to show all the ones that are null...

I am not 100 percent understand what you are talking about. I am new at this so bear with me. I selected the field I wanted to query from my table. I was thinking that you would put a command in the criteria section. I do not get where to put the expression you gave me. ? Thanks, Scott

This is a very simple question and I have tried to find the answer looking through older posts but cant. I am making a query and want it to show everything but something in a certain field. I know what I want it not to show. What is the command to make it do that? Thanks, Scott

Thanks for the help. I appreciate all the help from everyone. Scott

I have now created my report and would like to send it to my boss. How do I go about doing this. I am sorry if this is a very simple question. I have tried the send to:mail recipient and that does not work. Any help is appreciated. THanks, Scott

I am trying to query percent complete for different tasks. So in the query, I take the percent complete field and in the criteria, I put >"100" Or "0" Or "Null" I am only seeing results for the numbers 99 through zero, which is good. My problem is that I also have some blank spaces in my...

My originial expression is Expr1: [Dollars Expended]-[Amount Invoiced] I tried Expr1: [Dollars Expended]-[Amount Invoiced] "As <EXP Bill>" That did not work and I have tried it a few other ways. Sorry if these questions are very simple but I am very new to this. Scott

I had to put expressions in some of the fields of my query and I would like to change the field name to a different name besides espresion1 or expression2 or so on. I try to go to properties of each field and change it there and it will not let me. Any suggestions? Thanks, Scott

Heres the problem. I have a person that is updating all the information in Excel on a different computer. I need that information updated into the Access I am working on. I am trying to link from her folder on the network that has the updated information into access. I am able to link them...

I am very new to this and trying to learn as much as I can but what is wrong with the way I am trying to put this in. In the field box when trying to create my query, I am typing DateDiff("d," Start Date, End Date) Is this totally off? Any help is appreciated. Thanks, Scott

I have two dates in my table, a start date and end date. I want to be able to calculate the number of days are between the start and end date and the amount of weeks. How would I go about doing this in my query. :confused:

Let me start off by saying I am very new to Access. I have only read a tutorial on the program, so my knowledge is limited. I have an Excel spreadsheet filled with the following data which i would use as my fields task number (primary key) delivery order description customer group start...