Search results

  1. M

    Updating a linked Table field from Short Text to Date

    Hello, I am having issues with a linked table (in excel) not formating a date field as a date field. I have an online program that outputs all the information in One Excel Spreadsheet with Tabs. That Spreadsheet is linked to it's corresponding table in my database. Most of the Date Types are...
  2. M

    Help fixing a Calculated Data Type Error

    Hello, So I started creating a data base that has a number of calculated values to get Profit, Margins and Overhead. The Excel Spreadsheet that I get the data from includes decimal points, however, when I imported the data, it created it to be a long interger. Since Integers do not have...
  3. M

    Subs Report Overflowing into Each Other

    Hello, I have several design issues with a report that I am creating. This report has the following: Project Name and Data at the top 3 subreports in the main body, 2 that are above and below each other Project Financials and Invoices at the bottom The Problem that I am running into is that...
  4. M

    Correct Quarrie Syntax Question

    So this seams to be an easy request, but I can't figure out how to word it. My boss is doing Performance Evaluations for everyone and wanted to Cross Reference Each Contractor with the Job That they worked on. The only way I know for sure is by checking to see if they have a time clock record...
  5. M

    Working with Dynamic Linked Data From Excel

    Hello Access World Users, I am working with an online platform that has an poor reporting system. It does, however have an export feature that sends all the data into a multi-tabbed Excel Spreadsheet. As this data is updated about 3-5 times a week into the same file, I was wanting to make it...
  6. M

    Hello From Atlanta GA

    Hello Access World Users, 17 years ago I used Access and designed databases every day. My Career lead me to many paths, none of which needed a working knowledge of this amazing program. I am now an office Manager for a construction company and this old skill has become a need once more. I am...
Top Bottom