Re: Temp Tables

From: Rick B (Anonymous)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 12:41:08 -0500

You would have to tell us why you think you need to create a temporary table
and what data you think you need to store in it.

Based on what you say below, I can't see any reason to create a temporary
table. Sounds like you are simple running a report of records that already
exist.

Give us more details.

Rick B

"JMorrell" <JMorrell@discussions.microsoft.com> wrote in message
news:CE646D48-787C-496A-91BA-A92ABBD4223F@microsoft.com...
> I believe that I need to create a temp table to hold data at runtime. Can
> someone give me information where I can find out more about temp tables?
>
> background --
> a user of my Leave Tracking db can either be a supervisor or an employee.
> If the user is an employee, I want to print out their leave data. If the
> user is a supervisor, I want to be able to print out all of their
employee's
> leave data.
>
> Tables are on a SQL server.
>
> What's the best way to handle the reporting requests?
>
> tia,
> --
> JMorrell

Relevant Pages

  • Temp Table
    ... I believe that I need to create a temp table to hold data at runtime. ... for an employee to look at their sick and annual leave ... whether they are a supervisor or just an employee. ... hold the user’s ID and any employee IDs that this employee may ...
    (microsoft.public.access.reports)
  • Temp Tables
    ... I believe that I need to create a temp table to hold data at runtime. ... a user of my Leave Tracking db can either be a supervisor or an employee. ... If the user is an employee, I want to print out their leave data. ...
    (microsoft.public.access.modulesdaovba)
  • RE: training records (part 2)
    ... Each supervisor has many courses ... sub-department, or in charge of part of a sub-department, or responsible for ... the supervisor is also an employee ... I need to trace dept and subdept for the trainee as well as the supervisor. ...
    (microsoft.public.access.tablesdbdesign)
  • RE: training records (part 2)
    ... benefit any employee (such as personal development or general business ... Subdept ... Each supervisor has many courses ... sub-department, or in charge of part of a sub-department, or responsible for ...
    (microsoft.public.access.tablesdbdesign)
  • RE: training records (part 2)
    ... benefit any employee (such as personal development or general business ... Subdept ... Each supervisor has many courses ... sub-department, or in charge of part of a sub-department, or responsible for ...
    (microsoft.public.access.tablesdbdesign)
Loading