Problem with Tabular Report

[bjb_x]

Hi All,

I am a novice user of Access and I have encountered a problem.

I am creating a stock/inventory level database for my work.

I have a stock information form for each item in our inventory, where for each item of stock I have a calculated 'Number of tubes left' field (this is calculated from a subform totalling the number of tubes used and subtracting it from the initial stock). This all works well.

My problem is when I come to generate a tabular report listing all of the stock items. The field that should display the 'TubesLeft' result is blank for all records, or only displays the open Stock Info Forms calculated result.

How can I get my Tabular Report form to show each Stock items 'TubesLeft'?

Sorry it's vague... I have tried my best to explain what is happening.

Ben

 

[plog]

You really need to be careful with the terms you use. Database, Table, Query, Form and Report are all distinct object types in Access and you shouldn't use them interchangeably or generically (e.g "report" to mean something that displays data, "form" to mean a window inside of access, "table" to mean a set of data laid out unformated in a columns and rows, etc.). So when you say..

Tabular Report form

I don't know if you are talking about a Report object or a Form object. So, let me offer generic advice: When you are trying to generate a Report you should solve all data issues in a Query. Do all necessary calculations in the query and just use the Report to format and show that data in a specific layout.

So, I think your issue is a Query issue. Can you post sample data from the table(s) that this report will be based off of? Include table and field names and enough sample data to cover all cases. Then post what data should show on the report based on that sample data from the tables.