RE: Report parameters

Tech-Archive recommends: Speed Up your PC by fixing your registry

What are the fields in the new table? What is the record source of your
report? I expect something like:
SELECT ....
FROM .... JOIN .... ON ....


--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

I've made the table with the unique records in them. I have added this table
to the qryLink which feeds the report. I have the text boxes set up in the
report footer, and now am trying to figure out how to link them...

"Duane Hookom" wrote:

Your table with the unique cost codes could have a field that stores whether
or not the code should be considered. You could then add this table to your
report's record source and use the field.

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

Thank you for that, yes our costcode/types do tend to change almost 2x per
year lately, so hardcoding may be more of a pain. If I put the cost codes/
cost types in a unique table, would I then add them to my report in a
subreport?

Laurie

"Duane Hookom" wrote:

I would not hardcode the two values since some day there may be one or three
or four. Whether or not a cost type should "not included in the total" should
be stored in a table some where (preferrably your table of unique cost types).

I wouldn't assume your codes won't change and I wouldn't want to maintain
expressions in queries or reports. I would maintain data in tables.

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

Hi. I need help writing an expression. On my report I have multiple cost
codes/cost types listed as well as their estimated and actual costs. I have
created 2 boxes where all the estimate costs and actual costs are totalled.
The problem is that there are two cost code/cost types that need to appear on
the report but not included in the total.

So far in this totalling box I have put =Sum([Estimated Cost]), but I need
to know what to add to this to NOT select the $$ values associated with cost
code/cost types 091110.05970 or 092110.05970. I have tried building a query
that would not include these cc/ct's but I don't know how to relate them in
this report???
.

Relevant Pages

  • RE: Timeline Report - error in code?
    ... to fix this make the report width as large as possible in design mode. ... "Duane Hookom" wrote: ... Microsoft Access MVP ... Dim intDayDiff As Long ...
    (microsoft.public.access.reports)
  • RE: Transpose data in a report-Field values broken down to separat
    ... "Duane Hookom" wrote: ... The main report record source I suggested earlier would limit the report to ... Microsoft Access MVP ... have any gift records displayed in the report. ...
    (microsoft.public.access.reports)
  • RE: On Close
    ... Microsoft Access MVP ... The only code i have in previewing the report is: ... Private Sub Report_Open ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • RE: Transpose data in a report-Field values broken down to separat
    ... Microsoft Access MVP ... "Duane Hookom" wrote: ... Then create a main report based on only the unique values of ID and Name. ... a query, along with my response, that explains the need further: ...
    (microsoft.public.access.reports)
  • Re: Report Sorting
    ... I've put my DB duties on hold for the moment to design & develop the ... "Duane Hookom" wrote: ... Microsoft Access MVP ... This particular report doesn't ...
    (microsoft.public.access.reports)