Re: Query won't accept 0

A query can't make up data. If there are no records for a given category,
Access has no way of knowing that that category exists.

If you've got a table that contains a single row for each of the categories,
you can join that table to the table listing categories using a Left Join.
In that way, there'll at least be one row (albeit with no category
information) for each category.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"CrownEquip-Jen" <CrownEquip-Jen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F0B985D1-9F07-43D4-BE29-513AF84BEF8C@xxxxxxxxxxxxxxxx
I have a query that if the criteria isn't met, it blows out the category
instead of making it a 0. The the report won't work. Example: My query
tallys
up how many "A", "B", and "C" priorities there are in the database. If
there
are none in a category, it just acts like that category doesn't exist. The
report is set up to look for "A", "B", and "C", so if one of them is
missing,
the whole report doesn't work. How can I get it to read as a "0"?


.

Relevant Pages

  • Re: update same field with criteria
    ... to delimit table or query names from fieldnames. ... Consider basing your Report directly on a Totals query rather than ... single row in eachtable is linked to every single row in the other ... Consider storing date data in a Date/Time field rather than a text ...
    (microsoft.public.access.queries)
  • Re: How do I communciate between my list and button
    ... >I need some help in knowing how to pass the item picked to the query that ... >use the same report for each time a different item is picked. ... If your form is named frmMyForm, and the listbox is named lstPickItem, ... use a Query with a criterion ...
    (microsoft.public.access.formscoding)
  • Re: Report data reverts to prev rec in tbl; qry for report is correct
    ... Without knowing how your report is doing the page numbering, ... I've a report that is built on a query. ...
    (microsoft.public.access.reports)
  • Re: Generate Different Reports from a single query
    ... not knowing the fields in your query or what you want the report to look ... have you tried using the report wizard to create the different reports ... could you post back as to what you have in the query ...
    (microsoft.public.access.reports)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
Loading