Update Report
in [Reports]
|
Prev: Help needed - want to count categories within a category on a repo
Next: charts from Data just in two different reports
From: tsquared1518 on 2 Mar 2010 14:45 The filter property is blank, the filter on property says no. I may just try starting the report from scratch. "Duane Hookom" wrote: > If the records are in the datasheet view of the report but don't display in > the report then I would check the filter property. Also, make sure the > controls are in the proper sections of the report. > > -- > Duane Hookom > Microsoft Access MVP > > > "tsquared1518" wrote: > > > The datasheet shows everything that I want to display in the report. All Work > > Orders will have at least 1 Order Item, so that won't be a problem. > > > > "Duane Hookom" wrote: > > > > > Does the datasheet show everything that you want to display in the report? > > > > > > One thing to keep in mind is that no Work Orders will display that don't > > > have Order Items. If this is an issue, change the JOIN to include all records > > > from the Work Orders table. > > > > > > -- > > > Duane Hookom > > > Microsoft Access MVP > > > > > > > > > "tsquared1518" wrote: > > > > > > > Here is the sql view of the query. > > > > > > > > SELECT [Work Order Main Info].[Work Order#] AS [Work Order Main Info_Work > > > > Order#], [Work Order Main Info].Customer, [Work Order Main Info].[Customer > > > > PO#], [Work Order Main Info].[Date Issued], [Work Order Main Info].[Ship > > > > Date], [Work Order Main Info].[Approved By], [Order Items].ID, [Order > > > > Items].[Work Order#] AS [Order Items_Work Order#], [Order Items].[Seal > > > > Profile], [Order Items].Material, [Order Items].Quantity, [Order Items].[DVL > > > > (inches)], [Order Items].[Total Length (ft)], [Order Items].Configuration, > > > > [Order Items].[Valve Type], [Order Items].[Valve Location], [Order > > > > Items].[Valve Length], [Order Items].Notes > > > > FROM [Work Order Main Info] INNER JOIN [Order Items] ON [Work Order Main > > > > Info].[Work Order#] = [Order Items].[Work Order#]; > > > > > > > > "Duane Hookom" wrote: > > > > > > > > > What do you see in the datasheet view of your record source? What is the SQL > > > > > view of your record source? > > > > > > > > > > -- > > > > > Duane Hookom > > > > > Microsoft Access MVP > > > > > > > > > > > > > > > "tsquared1518" wrote: > > > > > > > > > > > The Record Source is my Work Order Main Info Table, which is linked to my > > > > > > Order Items Table. I have a form to enter this info into the table, the Main > > > > > > Form being the Work Order Main Info table, and the subform being the Order > > > > > > Items Table. Is it not updating because the Record Source should be the > > > > > > query? I will keep working on it. > > > > > > > > > > > > "Duane Hookom" wrote: > > > > > > > > > > > > > Open the report in design view and find the record source. View the record > > > > > > > source in design and try to troubleshoot. > > > > > > > > > > > > > > If you can't figure out your problem, come back with what you have discovered. > > > > > > > > > > > > > > -- > > > > > > > Duane Hookom > > > > > > > Microsoft Access MVP > > > > > > > > > > > > > > > > > > > > > "tsquared1518" wrote: > > > > > > > > > > > > > > > I have a report that doesnt show all of my data from the table. It worked the > > > > > > > > first time, then yesterday I added more entries. It only shows the older > > > > > > > > entries now. I'm sure this is probably something simple that I'm overlooking, > > > > > > > > but can someone please tell me how to get my Report to update so that it > > > > > > > > shows all records in the table every time? Thanks for your help!! |