Problem with Access snapshot report

[blm]

I have inherited an older VB6 program whichs calls Access to produce reports. One of the reports that was run today should have had a row of data with a column containing a negative number. The entire row of data did not show up on the report. When I run the query the report uses it does show up. There does not appear to be any conditional formatting associated with the fields or the detail line of the report. I tried formatting the column itself, but this didn't help. I know nothing at all about these Access reports and the programmer that added the reports is no longer here. Can someone point me to where I should look please?

 

[dilettante]

Doesn't sound like any VB6 issue there at all if you're just automating Access. Maybe check the Access forums for a topic area covering this, there are a number of Access forums here.

 

[tedsmith]

Sounds to me like the SQL statement for the VB6 query has a flaw and is generating an error or interpreting that row as not matching when the row with the negative field is encountered.
Also, maybe somewhere it is wrongly formatted to byte (0 to +255) and not an integer or long?
How is the data presented in the vb6 version, in a datagrid or just plain text?
Do you have the original sourcecode for the VB6 program?

Also if there was a WHERE clause in the internal vb6 query criteria like "WHERE MyRec!MyField > 0" then obviously any row that was negative wouldn't show up!

 

[blm]

In case anyone has a similar problem, I found the overall report properties by selecting design mode of the report and then View/Properties. The report had a filter limiting the detail to values > 0 on this column.