Databases
StackOverflow2013
Usersdbo
USepilimic
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USepilimic
    primarykey
    data
    text
    plurals
    1. POMs Access 2007 - Can sort or group report but not both, can't figure out why
      singulars
      1. PTQuestion
    2. PODuplicate instances of records flooding my Access report
      singulars
      1. PTQuestion
    1. POjquery will drag items but I can't re-order them
      singulars
      1. PTQuestion
    2. POincrementally un-hide input boxes and text with 1 button
      singulars
      1. PTQuestion
    3. POSubmitted info not passing through
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. COYes and this limits the entire query to just that many results. I need it limited on a per-customer basis instead of an overall limit.
      singulars
      1. POAccess - Limit records in a report so they don't spill over to the next page
      1. USepilimic
    2. COThat looks absolutely perfect. The output is just how I'd like. See, the database that I'm working with is an old one that was in place already, but had problems. It has a broken version that is similar to this, with a subreport inside. It's issue is that the outputs had duplicates, as in another full copy of the contact and all sale history at EACH date that was listed, and it was making my report a disaster. I posted around to a couple forums and a couple people questioned why I didn't just do it with a single one. So I basically tried to recreate what was needed. Let me give this a try. TY!
      singulars
      1. PO
      1. USepilimic
    3. COHrm. So after going back and reviewing the results, it doesn't appear to be grouping properly still. I'm getting duplicate records showing up. What is happening is for each instance of a paid date, I'm getting another full record. I only need one instance of info from the tblContributorsLead and each instance from tblPledgesLead to be contained within that one single contributor lead. For reference, if you search the phone number 555-254-2995 you will find a copy of the entire lead with both paid instances on pages 41 and again on 742. The "copy" from 742 shouldn't be appearing.
      singulars
      1. PO
      1. USepilimic
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload