Search results

Is there a way in a Make-Table query to tell the table to open when it's created? I would assume there is a function or SQL code that would do this, but I know very little SQL. Can anyone point me in the right direction? Thanks!

:confused: Can anyone tell me what might be wrong with this expression? It is returning "-1". =(IIf([Forms]![AnnualDialog]![Dept]=41,"Casing") Or IIf([Forms]![AnnualDialog]![Dept]=64,"Open Stock")) A parameter (either 41 or 64) is entered on a form (AnnualDialog) and the expression above is...

Hiya! I would like to start by thanking everyone for their time and expertise!! I created a report with 4 subreports. Each subreport is based on a different query but the same parameters apply to each subreport. When I opened the report, I had to enter the parameters 4 times, one for each...

Hiya! I am using Access 2000 and need to write an event procedure that tells a report to open the subreports within it upon open. I have attached a form to enter parameters for the reports, so my hope is that the form will provide the parameters for all the subreports. I have no idea how to...

Consider me a newbie for this thread!! I am trying to create a report with 3 sections, DIRECT HOURS, INDIRECT HOURS, SUMMARY. The information that needs to be viewed under each section is based on a separate union query. Each query is based on parameters, the same parameters apply for each...

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?

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...