Form and Report help

[Guest]

Hello,

I am new to Access and I am trying make a Fee Schedule for work. I have
been able to set up a form with the services, unit price, and list total.

What I want to do is be able to enter quantity values for certain services,
and have only those services appear on a report (instead of all the
services).

Any ideas on how to do this?

 

[PC Datasheet]

You need Quantity in your table and you need to base your report on a query.
The criteria for Quantity in the query needs to be "Is Not Null".

 

[Vincent Johns]

Depending on the OP's needs, it may be advisable not to store the
[Quantity] value in the Table. For example, perhaps the Table is a
price list, and the report is intended to reflect some customer's order.

To avoid changing this [Services] Table containing the standard price
list, the [Quantity] and [ServicesID] values could be included in a
separate [Order Details] Table (in which [ServicesID] is a foreign key
pointing to a record in the [Services] Table). The [Order Details]
Table might also include an [OrdersID] link to another Table, [Orders],
which would identify the customer, order number, date, etc. See the
Northwind database for examples.

If the Query on which the Report is based identifies the [OrdersID]
value, then there would be no need to look for "Is Not Null", as the
value of [OrdersID] would select only the relevant records, and the
total would include only those.

(Of course, what I suggest here makes sense only if I guessed correctly
as to how this report is to be used.)

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.