Search results for query: *

Hello all, I have a few queries that I am able to export to excel. However, with one of them, When I export the query it just gives me the header row and no data. In Datasheet view the data is displayed. Query Looks Like this: SELECT DISTINCTROW SHA.* FROM SoftwareListing AS SHA...

Is there a way to format the output in access. I have been looking on the web and I see that you can set a template in Excel, but it won't allow indentation or fields to be set in rows and columns. For e.g. i want the output to be like C A B where C, A, B are all fields and would be...

I have 2 queries and both run fine seperately, but when I combine them to get one file, it just messes up the numbers. The following is the combined query: SELECT Sum(E.[Total Amount]) AS [Total Amount], sum(IIf(E.Code<>7777,(E.[Total Amount]))) AS [Total Amount To A]...

Hello all, I have a table with some IDs. A group of IDs is 777 and the rest are all different. Each ID has an associated amount with it. I want to generate the sum of amounts for all IDs with 777 and all the other IDs. So, I would end up with 2 aggregate amounts - SUM of IDs 777 SUM of IDs...

SELECT DISTINCTROW T.ID, T.CustomerAccountNumber FROM TransactionReport T, UCustomerNumbers AS U WHERE T.CustomerAccountNumber<>U.CustomerAccountNumber; For every record in the Transaction report, I want to ensure that a matching CustomerNumber was found in the U table. I am trying to list all...

Trying to run the following query: SELECT T.ID FROM ExpressMailTransactionReport AS T WHERE ((T.ShipmentCharge = 0) Or (T.ShipmentCharge = Null)) ORDER BY T.ID; ShipmentCharge is a number - thanks

Hello all, What I have is a table with two fields: IDs and expenses. multiple occurences of a single ID are possible and will happen. What I need to do is get the total expenses incurred per ID. Not too sure if I need to use the sum functionality or if there is another way to do it. Thanks in...

I have two tables, and what I want to do is find the matching records and find the records that don't match. For instance, I want to know what records are in Table A but not in Table B and vice versa. My code looks like this but it is giving me more than 3 mil. records. I think for every entry...

The scenario is: I have 3 tables. Commercial: NewPrice, OldPrice, Weight, Zone, ServiceType Residential: NewPrice, OldPrice, Weight, Zone, ServiceType TransactionReport: Price, Weight, Zone, IsItRes (a boolean) Task at hand: Write a query, which takes all the records in the transaction table...

what i am trying to do is read entries from TransactionReport, if the IsItRes field is true, compare the entries in the TransactionReport table to the Res table otherwise compare to ComTable Query doesn't work.. please help SELECT CASE WHEN IsIsRes = TRUE THEN SELECT...

The scenario is: I have 3 tables. Commercial: NewPrice, OldPrice, Weight, Zone, ServiceType Residential: NewPrice, OldPrice, Weight, Zone, ServiceType TransactionReport: Price, Weight, Zone, IsItRes (a boolean) Task at hand: Write a query, which takes all the records in the transaction table...

The scenario is: I have 3 tables. Commercial: NewPrice, OldPrice, Weight, Zone Residential: NewPrice, OldPrice, Weight, Zone TransactionReport: Price, Weight, Zone, IsItRes (a boolean) Task at hand: Write a query, which takes all the records in the transaction table, first of all checks...