Hi,
Having a problem within my database. I have a form "Costing Sheet RL Form"
Within this form I enter the data I want for a report. The first button "Run Macro" runs a macro that runs a qry " Delete record from Costing Sht Hdr tbl qry" which deletes the record from the last request. Then runs a query "Append record to RL Costing Sht Hdr tbl qry", which brings in the forms data. Both of those work. But then the second button runs a macro "Costing Sheet RL Report Macro. The first query in this macro is "Costing Sheet Hdr Make tbl qry" and this query is appending what was requested in the Report form plus the other record in the table where everything is the same except Route#. And I have my query criteria to match what the Route # was in the form, so why does it append the other route# also???
I'm attaching a sample of my database to look at with only the records in questions.
The outcome is the report Costing RL Sheet. And if you look at the report out there you will see my data is duplicated because of this.
Any help would be appreciated.
Thanks!
Having a problem within my database. I have a form "Costing Sheet RL Form"
Within this form I enter the data I want for a report. The first button "Run Macro" runs a macro that runs a qry " Delete record from Costing Sht Hdr tbl qry" which deletes the record from the last request. Then runs a query "Append record to RL Costing Sht Hdr tbl qry", which brings in the forms data. Both of those work. But then the second button runs a macro "Costing Sheet RL Report Macro. The first query in this macro is "Costing Sheet Hdr Make tbl qry" and this query is appending what was requested in the Report form plus the other record in the table where everything is the same except Route#. And I have my query criteria to match what the Route # was in the form, so why does it append the other route# also???
I'm attaching a sample of my database to look at with only the records in questions.
The outcome is the report Costing RL Sheet. And if you look at the report out there you will see my data is duplicated because of this.
Any help would be appreciated.
Thanks!
