Search results

  1. G

    Column headers based on values in a table

    so i think i figured out how to solve my issue by using the crosstab query and then generating the report based on this query but the problem i am facing now is that i need to run this report every 3 months meaning that in march i will see january february march as the column headers then 3...
  2. G

    Column headers based on values in a table

    I have a table with the following info Name | Dept | Month | HrsWorked | Cost John BA Jan 09 20 500 John BA Feb 09 30 600 Sally DEV Mar 09 40 600 And i want to generate a report that will look like this Dept | Jan 09...
  3. G

    Populating SubForm based on text entered in fields in Main Form

    I have 3 tables: Projects: ProjectCode ProjName Desc StartDt EndDt Department: DeptID DeptName Estimates: EstID fkDeptID EstHours DailyCost EstBudget (basically EstHours * DailyCost) now i want to create a form where i can add the estimated budget for a project by inserting est hours and...
Top Bottom