Search results for query: *

Hi! I have an access table that I built, but then I needed features in excel so I have now have a spreadsheet link to the table. The data gets entered in an access form. The problem is that when I linked the table and spreadsheet it changed "memo" fields to "text" fields and...

Thanks all for the help - I have decided to put the chemicals in a seperate table - I can see the advantages to this. Thanks! Leigh Ann

Okay I am probably doing something wrong, but I put this: Option Compare Database Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.BENZENE = 0 Then Me.BENZENE.Visible = False Else Me.BENZENE.Visible = True End If End Sub and I am getting the message error...

Yes that is a crucial to know. They are fields in a single record in a table.

I tried to do this. And my table has 173 records and when I run the query it comes up with 0 records. Thanks [sunshine] Leigh Ann

Thanks for looking at my message and change my title to Beginning Programmer. I have a report that has 20 fields that are chemicals. I only want to print on the report any chemical field whose value is greater than 0. For example I may have Benzene 2 Chlorobenzene 3 Toluene 0 Xylene 0 Aniline...