Search results

  1. S

    getting "overflow" message when querying percentage

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

    Search for everything "but" something

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

    How to send a report through email

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

    Not showing all results I query

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

    How to change field names in queries

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

    linking from excel to access

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

    Calculating number of day in a query

    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:
  8. S

    Question on where to start

    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...
Back
Top Bottom