Search results

Got it figured out...the cause of the problem was another filter I wrote in VB that took out certain numbers if they did not equal a certain amount in the Balance field.

Just to test things out I've removed all grouping and sorting and still am not able to see the duplicates. Yet I can see thm in the underlying query. Any other suggestions?

Though you were correct in the Contract Numbers being grouped when I ungrouped them I still havethe same issue.

I have an Access Report where any where where I have a duplicate contract number that whole record is hidden. What is confusing is that the underlying query shows the duplicates how I want. I checked the properties and "Hide Duplicates" is off. Unfortunately it still hides the duplicates on the...

I have a query that pulls data just like I want in SQL Server 2000. However I need to add a header and trailer row so that it appears as: HEADER (contains various name information, but also a time stamp) Detail1 Detail2 Detail3 Detail4 TRAILER (should just show the amount of detail records)...

I have a report that is created based off a form. For some reason the first line of the report is has some blank spots where data should be. When I click to go into design view, then click again to come back to print view the data that was blank now appears. Not sure why this happens...its...

I wasn't to sure about the GROUP BY question, I forgot to address that. I was given the query and told to just schedule it to be able to export. The DTS solution you suggested worked perfectly. Thanks!

I know that the query works...I have ran it in SQL Server (version is 2000). However I cant get it to run using the BCP command. I may be using the wrong format. I wrote it like: BCP "SET QUOTED_IDENTIFIER OFF SELECT EMP.EMPCODE, EMP.LASTNAME, EMP.FIRSTNAME, EMP.CRAFT, EMP.CREW...

I have a query that works in SQL Server. However when I try to put it in a scheduled job using the BCP function I cannot get it to work. I want the output of my query to be written to an excel file (.csv file is fine). SET QUOTED_IDENTIFIER OFF SELECT EMP.EMPCODE, EMP.LASTNAME, EMP.FIRSTNAME...

I may have misinterpreted the ISError Function...I thought it would return a boolean true if there is an error or a boolean false if there is no error...it seems that when there is an error it just displays the error.

I have an If statement in a text box that does a calculation. This IF statement is enclosed in the IsError function. However whenever there is an Error as opposed to displaying a "1" it says #Div/0 or #Num. Shouldn't it say "1"? When there is no error is says "0".

In my report I have some code that hides rows that meet a certain criteria. However I do NOT want to include the hidden data in the Sum. Nevertheless it is still calculated in. I am using a text box with a running sum as my SUM. Any clue on how to ONLY include the visible rows?

That does not work unfortunately. Access just crash with the message " Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience."

I cannot put in my original field because it is an equation with aggregate operations in it.

Rich, I tried that out but here is the deal... In the group footer I use the textbox name from the details section. In my case the textbox with the right running sum was called 'Month1Sum'...therefore in the group footer I set the control source to '=[Month1Sum]'. However when I put...

Just to test out that my forumla was correct I put in a text box to show a count by entering '=1' in the control source and summing over the group. Even the count of the group is incorrect in the footer when compared to the details section.

It's kinda confusing what I have in the design view but here is a quick glimpse of the report area I am referring to. The area points to the group footer of the incorrect sum. However I have circled in red the running sum. All I did was assign that running sum to another text box in the group...

I have a report that contains a text box in the 'Detail' section that has a running sum over the group. In the group footer section I have another text box that is suppose to display the final sum of that running sum. However the total continues to be off. In the 'Detail' section when it reaches...

Query SQL? Wait...I'm confused. I dont have any behind the scene code or anything. I'm doing this in Excel. The pivot table was made by someone else. All I know how to do is click on the individual cells and bring up the filtered sheet which I can vary data with.

How do I check for this as you've stated? Also I notice when I change the way the list is filtered I will be that same miscalulation for different rows/columns.