avoid listing empty fields in a record?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Greg (anonymous_at_discussions.microsoft.com)
Date: 02/06/04 

Date: Thu, 5 Feb 2004 23:06:54 -0800

i have a table with just one field listed. with this,
some of my records are empty which of course leaves an
empty spot which is what i want. when i have the DB Wiz
displaying all this on a page, it leaves a space where
that record is empty. I want it to just list the records
with info in it and not the blank ones which leave a
gap. how do i do this? Thanks!

Relevant Pages

  • Re: Help with "clusters" of plotted data
    ... In your data range, list every date, and keep the cells next to weekend dates empty. ... The lab doesn't generate data over weekends/holidays, so I'll have a bunch of data points from M-F dates, but then there is a gap in days then the data starts flowing again. ... When I plot this data using the X-Y graph, I'll have clusters of 5 days worth of data...a 2 day gap on the x-axis for the weekend and then another cluster. ...
    (microsoft.public.excel.charting)
  • Re: Start Menu / Programs wont populate
    ... Start Menu - 'All Programs' is empty or nothing happens when you click the menu: ... |> displaying the contents of the Programs menu. ... |> b) I have checked the contents of the Start Menu folder for All Users ... |> not the individual users programs. ...
    (microsoft.public.windowsxp.general)
  • RE: macro to copy text
    ... Insert one or more empty rows in table x. ... Leave the cell for the numbering empty. ... Check wich cells in column 1 are empty ... then the "gap" rows where deleted. ...
    (microsoft.public.word.vba.general)
  • switch function in reporting services
    ... I have a switch function that is not working properly. ... syntax error, but it is not displaying any data. ... empty. ...
    (microsoft.public.access.queries)
  • Re: Contacts display but not when typing message
    ... There is a box which appears in the right hand corner and it was displaying ... So my question is now how to get rid of the first two which are empty or to ... Dave Neve ... PS: Running Microsoft Office 2003 ...
    (microsoft.public.outlook)