Search results

I have created my first Make-table query and it actually worked!!!Yeah! But now, is there a way to make this table updateable each time the query is run?

Please Help - No Column Fields to Create a Report!! :confused: Let me start over. My overall goal is to create monthly, quarterly and annual reports. I have a Fiscal Calendar Table and a Production Table set up and there are approximately 20 crosstab queries pulling info that make up the...

Paul thanks for the info, I should have provided the info that I am using Access 2000. Anymore ideas would be appreciated. I have been using Access for a while, but nothing this complicated. Thanks again!

I am using Access 2000. I have created a crosstab query to run monthly reports based on a fiscal calendar year. My problem is that my column heading is a parameter [Fiscal Period] that returns the fiscal week #s as column headings and they change for each fiscal period. I cannot find a way to...