Re: Multiple Tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I was able to link it through subforms by linking the name and the date on
the master/child fields. The only reason I was trying to go a different
route was because I could not get the information to report correctly, it was
just coming from the main form rather than all the forms. If you knew a way
to print the subform results as well as the main form results, I would be
able to keep the subform format. It was easier than this, that's for sure.

"Cortney" wrote:

> SELECT [AR Aging Percentages Query].[Billins Address Subgroup], [AR Aging
> Percentages Query].[Commercial/Blue], [AR Aging Percentages
> Query].[Contracted/Non Contracted], [AR Aging Percentages Query].Date AS [AR
> Aging Percentages Query_Date], [AR Aging Percentages Query].[Full Denial as a
> % of A/R], [AR Aging Percentages Query].[A/R balance 0-90 Days], [AR Aging
> Percentages Query].[AR Balance 0-120 Days], [AR Aging Percentages Query].[AR
> Balance 0-181 Days], [AR Aging Percentages Query].[A/R Balance > 181 Days],
> [Payments to Charges Query].[Payments to Charges Ratio], [Days Billed
> Outstanding].[Days Billed Outstanding]
> FROM (([Payer Table] LEFT JOIN [Payments to Charges Query] ON [Payer
> Table].[Billins Address Subgroup] = [Payments to Charges Query].[Billins
> Address Subgroup]) LEFT JOIN [AR Aging Percentages Query] ON [Payer
> Table].[Billins Address Subgroup] = [AR Aging Percentages Query].[Billins
> Address Subgroup]) LEFT JOIN [Days Billed Outstanding] ON [Payer
> Table].[Billins Address Subgroup] = [Days Billed Outstanding].[Billins
> Address Subgroup];
>
> Billins Address Subgroup Commercial/Blue Contracted/Non Contracted AR Aging
> Percentages Query_Date Full Denial as a % of A/R A/R balance 0-90 Days AR
> Balance 0-120 Days AR Balance 0-181 Days A/R Balance > 181 Days Payments to
> Charges Ratio Days Billed Outstanding
> BCBS OF
> TN Blue Non-Contracted Sep-05 53.69% 54.99% 62.27% 76.84% 23.16% 73.13% 143
> BCBS OF
> TN Blue Non-Contracted Oct-05 56.52% 47.70% 57.99% 70.16% 29.84% 73.13% 143
> BCBS OF
> TN Blue Non-Contracted Sep-05 53.69% 54.99% 62.27% 76.84% 23.16% 79.14% 143
> BCBS OF
> TN Blue Non-Contracted Oct-05 56.52% 47.70% 57.99% 70.16% 29.84% 79.14% 143
>
> This doesn't look pretty but the problem is that the last two entries,
> Payments to charges ratio and days billed outstanding are not linking with
> the date field in the Payer Profile table. It is duplicating the entries in
> each month. In this instance, there are two months of data in the payer
> profile, there is an entry for each month in the Payments to Charges Ratio (
> Sept is 73% Oct is 79%) but there is only one month in the days billed
> outstanding field(Oct is 143) . It is pulling the numbers in for each month
> whether is corresponds with the correct month or not. I was wondering if I
> could join the date fields somehow or do I need to set up my tables
> different? Each table has a date field with the format mmm-yy.
>
>
> "John Vinson" wrote:
>
> > On Tue, 22 Nov 2005 08:02:08 -0800, "Cortney"
> > <Cortney@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> >
> > >I am still having the problem with the date fields. The are not linking up
> > >to the correct date from each table. Do you know how to fix that?
> > >
> >
> > No, I don't - because I cannot see your table structure or your query
> > or the results you are seeing.
> >
> > You can see your computer. I cannot. You're doing something wrong in
> > the query, but I don't know what the query IS because I cannot see it.
> >
> > Please open the query in SQL view and copy and paste it to a message
> > here. Also give an example of what's in the table, and what you're
> > seeing that is not "linking up".
> >
> >
> > John W. Vinson[MVP]
> >
.

Relevant Pages

  • Many to Many / Junction Table / Form & Subform
    ... time since I last built an Access DB and I'm struggling with something. ... I then based the subform on this query. ... seem to be linking them. ...
    (microsoft.public.access.forms)
  • Re: Carry the Key ID field to subforms when entering new records
    ... Why is the form bound to a query with multiple tables? ... ADDRESS subform, being a true subform, has parent and child linking ... Both the Orders table and the LineItems table will have a common field ...
    (microsoft.public.access.forms)
  • Re: How to get rid of blank line in a Subform w/in Form
    ... Is there any other way to get rid of the "add" line? ... if I am linking the subform in within the main form using a primary ... within the main form if the subform is based on a query (relating 2 ... if I am linking the subform in within the main form using a primary ...
    (microsoft.public.access.formscoding)
  • Re: Blank Forms
    ... There are no records in the query upon which your form is based. ... if the form source does not find any records and if you can't add ... > When creating a form and linking that form to the query, ... > This also happens if I create a subform. ...
    (microsoft.public.access.forms)
  • Re: How to get rid of blank line in a Subform w/in Form
    ... you could set the Allow Additions property of the subform to No ... if I am linking the subform in within the main form using a primary ... > within the main form if the subform is based on a query (relating 2 ...
    (microsoft.public.access.formscoding)