Search results for query: *

PHV, I think you missed a bracket and I don't know how the 2 joins are beig combined? Thanks, m.

Mark, I am a novice user, picked up Access a few months ago and I have been learning on the fly - thanks to all the ppl on this site. I tried using Access's reporting functionality and quite honestly I felt its limitations due to the extensive data I was dealing with. I am just reporting my...

Hello, In my opinion Access itself is a fairly limited reporting tool. However, that depends on the formaat of your report. If its in excel, you can create a template and force access to generate reports in that specified format. Otherwise you might be better off with something else. If you do...

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 guess its a work around - but this was just a sample, I am dealing with approximatley 30 calculations. It will be harsh! Thanks for the idea - M

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]...

Thanks cmmrfrds, appreciate the help.

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...

Thanks Leslie! worked like a charm.

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...

makes sense - cheers!

Thanks drctx and PHV. The error I was getting was that it would not print any output. But PHV's code worked. PHV why do I need to use the NZ function. I am generating other records where the conndition is T.ShipmentCharge = 0 and it works fine. Is there a logical reason behind why it would...

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

This is what my code looks like.. but no luck SELECT A.Name, A.Number, B.Name, B.ID, B.Number, A.Expenses FROM A, B WHERE A.Number = B.Number Group BY B.ID; Thanks again!

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...

Thanks PHV, let me try this. How you been by the way? Hope you not upset at me.

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...

No, Not Yet.

Yea you are right. PHV, I apologize. Consider it to be frustration on my part. Quit smoking yesterday, usually I am not so edgy. Hopefully you can understand. - Maria