Search results

  1. D

    Output not showing on Report - Why?

    I created a Report from a query. The query shows the correct data that should be on the Report. I created the report to sort by Field A and then sum Fields D, E, & F. None of the query data shows up on the Report. I;m stymied as to why I can see data on a query, but the ONLY data that shows up...
  2. D

    Type mismatch error on report

    I have a database as follows: Date1 Name Issue Action_Item1 Status1 Action_Item2 Status2 ..... with up to 5 max action items/status; where Status is a checkbox I ONLY want the report to return records where there is text in an action_Item input AND the corresponding status is FALSE. The...
  3. D

    Report with partial open records

    I have a database as follows: Date1 Name Issue Action_Item1 Status1 Action_Item2 Status2 ..... with up to 5 max action items/status; where Status is a checkbox I ONLY want the report to return records where there is text in an action_Item input AND the corresponding status is FALSE...
  4. D

    Calculate on a form

    I have a form field that I would like to perform a calculation upon the exit from a second form field. For instance... FormField1 is a quantity showing how many "units" were created for the day for the Category "Scrolls". I also have a table in my database containing 6 Categories - including...
  5. D

    Multiple users on database at same time

    Thanks in advance for helping a newbie trying to become something... I've created a database for use amongst 3 Production departments. The database is on a shared drive on a corporate server. How do I handle the saving of the data if all 3 departments decide to input into the database at the...
  6. D

    Need to calculate value within a report

    I consider myself a newbie, thanks for bearing with me. I have a GROUPED report as follows: Date by Day Dept or Loc Date Shift Total Good Orders Total Rejects Total Manhours After a date range input, the report groups Dept or Loc, then for each shift, the report displays Total Good...
  7. D

    Text Box results based upon separate input

    Thanks in advance for the assist. I have a CODE table with 2 columns, Code & Description. I have a form where I input a CODE value; I want a second text box to retrieve the corresponding description from the CODE table. I'm a newbie and am unable to make this occur successfully. I don't want to...
Top Bottom