Search results

GOT IT !!! YAHOO!!!!.... this was a wopper.... Oh Sorry... Here's my fix to the query from "hell" PUT_CALL: IIf([SECURITY SUB-TYPE] Is Null,'',IIf([SECURITY SUB-TYPE]='','',[SECURITY SUB-TYPE])) That worked... The [SECURITY SUB-TYPE] field has (so I thought) 3 distinct postings 1. C 2. P...

now I'm just going on randum data mining hunts on this issue... this really has me miffed.... but I'm not going to let this lick me.... am now removing one of the fields in the query and re-running (am doing this to all the fields in the query) HEY.... I found something ( i think ?) one...

outlining the process I've taken thus far... not sure what else I can do... :confused:

This is where I really get confused.... But I'll try to explain I've removed the additional uneeded fields by taking the data from the query and created a seperate table using only the required fileds... I then try to Group by on the seperate table and I'm still getting two lines oh ... and...

When you asked me are the office numbers the same? I'm not sure Im understanding your question... The Office number field is a text field with numeric characters In this query the office number is the same... The account numbers have differences and are also text numeric characters

Hi Brian that didn't work not sure why... Am grouping on 7 fields (although I did reduce to three for this test)... and then summing on the last two... still getting two lines .... should only be one :(

SQL of query: SELECT tblPhilipsPos.[OFFICE NUMBER], tblPhilipsPos.[ACCOUNT NUMBER], tblPhilipsPos.[EXCHANGE CODE], tblPhilipsPos.[FUTURES CODE], tblPhilipsPos.[CONTRACT YR/MON YYYYMM], tblPhilipsPos.[SECURITY SUB-TYPE]...

Hi In Access 2003 using a query to group by and sum on 2 fields [BUY SIDE QUANTITY] , and a seperate field to sum on [SELL SIDE QUANTITY] Am importing data from 2 sources and trying to sum within access I have the following: see attached The Fileds are data type "Long Integer" in the table...