![]() Maybe I am going about the whole process incorrectly. If these references are to the text in the category field than there will be an issue as "not clothing" is not a category, it was ment to mean all categories except clothing. I'm not sure how to fix this.Īlso I noticed that your if clause has "clothing","clothing", and "not clothing" listed. I got an error message: You tried to execute a query that does not include the specified expression 'Round(,2)' as part of an aggragate function. I entered your code into a new query and ran it. My thought would be that since they are in the same table this 'join' already exists. It seems redundant to join a table to itself. In response to your comments on the potential problems if a category has no sales, right now tblCat is where I am storing the Category and the Tax Rate Information so I don't know how I would join them in an outer join. I also added the prefix CLO to all the calculated fields in the Clothing only query.įrom my understanding of your reply, I would create a third query to base the report on that 'grouped' both queries on the same fields. Then I modified the criteria in the Category fields one only clothing and the other not clothing. (I actually created a genaric queary to find all categories for all the fields that I wanted then I saved as to create an exact copy. Just for clarification both quearies are based on the same fields, there is just a different criteria in the Category field. You suggest that I "grouping" both quearies on the same field. My lack of training is shining through again. Also I have no real understanding of code yet so if I need to use code to facilitate this I will need some very detailed guidance. As you can probably tell I'm relatively new to this program. ![]() I also used the Total Clothing Sales from the sepearate query as a control source for an unbound box in the footer section of the Sales Tax Report but when viewed in preview the field had only #Error displayed.Īny advice for how to do this would be appreciated. I tried creating a seperate query to calculate the Total Clothing Sales and then including it in qrySalesTax So that the Total Clothing Sales were listed seperately in the query, but the queries 'overlapped' and I got cycling listings for the clothing transactions on the same lines as the other category transactions so I abandonded this idea. What I would like to do is to subtract the Total Sales for the category Clothing from the Gross Total Sales to arrive at the Amount of Sales Subject to Tax. I have a report based on the Queary that is grouped by Category, then by Month, with totals for each grouping and a Gross Total for the entire date range. I have a query (qrySalesTax) to find all sales within a specified date range that also calculates the Total Sales and the Total Sales Including Tax. ![]() The figures I need for this report are Total Sales(not including tax), the Amount of Sales Subject to Tax, and the Total Sales Including Tax, all gathered for a specific time period. I am working on a report that I could print when its time to file our State Sales Tax paperwork. I am working on an Inventory Database in Access 2003.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |