Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CMDennis

    Syntax for IIf statement

    I wrote a database to track corporate funds, both actual and forecasted and in the report, I would like to not report the forecasted for dates in the past. I want to write and "if" statement that will look at and use teh data in [Jan_2001_cap_act]if [Jan_2001_cap_for]=0. I have...
  2. CMDennis

    Linking Access and Excel for spreadsheet report

    I wrote a database that keeps track of all corporate expenditures (capital and expense) and will track them by month until 2008. My problem is that I would like to report the data in a spreadsheet format. I have 6 different queries that generate data. I need to have those queries...
  3. CMDennis

    Linking Access and Excel

    I wrote a database that keeps track of all corporate expenditures (capital and expense) and will track them by month until 2008. My problem is that I would like to report the data in a spreadsheet format. I have 6 different queries that generate data. I need to have those queries...
  4. CMDennis

    Creating a Report in a Table Format

    I am trying to create a Report for a database that tracks corporate expinditures. The report needs to be in a spreadsheet like format, but there are specific cells that must be formatted a certain way. Is there anyway to have the database calculated in excel, but it opens up an already saved...
  5. CMDennis

    Using a loop in VBA as part of a form exit macro

    I am writing a database which will hold all of the machines' names, their machine number, as well as whether or not PLC s are present. Some of the machines contain more than one PLC. I have a "Master" form, which contains a yes/no and quantity box. On update from the quantity box...

Part and Inventory Search

Back
Top