Report and Query

L

Luis

Hello:

I have report that will not calculate certain expression
for one record only...I went back to my querie from which
I created my report and the samething has happened...Do
you know why this happens? My querie is composed of 3
tables: preferred vendor, reimbursement, and fee
schedules summary...My reimbursement table is the one I
work from and link to the others....for whatever reason,
it is not picking up standard fee and medicare allowable
from my schedule summary also...The following is my
querie's SQL:

SELECT tbl_chemo_reimbursement_drugs.[2004 HCPCS],
qry_preferred_vendor_cost_final.NDC,
tbl_chemo_reimbursement_drugs.[2004 Billing Unit] AS
[BILLING UNIT], tbl_fee_schedules_summary_payers.
[STANDARD FEE], tbl_fee_schedules_summary_payers.MEDICARE
AS [MEDICARE ALLOWABLE], tbl_chemo_reimbursement_drugs.
[Vial Size], tbl_chemo_reimbursement_drugs.[Vial Unit],
qry_preferred_vendor_cost_final.[PREFERRED COST],
qry_preferred_vendor_cost_final![PREFERRED
COST]/tbl_chemo_reimbursement_drugs![Vial Size] AS [Cost
per mg], [2004 Billing Unit]*[Cost per mg] AS [Cost per
Billing Unit], [MEDICARE ALLOWABLE]-[Cost per Billing
Unit] AS Profit
FROM (tbl_chemo_reimbursement_drugs LEFT JOIN
tbl_fee_schedules_summary_payers ON
tbl_chemo_reimbursement_drugs.[2004 HCPCS] =
tbl_fee_schedules_summary_payers.[SERVICE CODE]) INNER
JOIN qry_preferred_vendor_cost_final ON
tbl_chemo_reimbursement_drugs.NDC =
qry_preferred_vendor_cost_final.NDC;

Thank you,

Luis
 
D

Duane Hookom

Not sure how you expect us to see your data? You are suggesting that your
data records aren't matching but we have no way of knowing what your values
are.
 
L

Luis

I have three tables: fee schedules,reimbursement, and
preferred vendor...
Fee Schedules look:
Code Standard_Fees Medicare_Amount_Allowed
H305 $1 $0.10
H306 $4 $0.77
H307 $10 $2.50
Reimbursement Table:
Code NDC Billin Unit
H305 534-456 1
H306 265-458 5
H307 347-125 4
Preferred Vendor (Crosstab Query) looks:
Code NDC Preferred_Cost OSN_Cost TON_Cost
H305 534-456 $0.20 $0.20 $0.45
H306 265-458 $0.35 $0.35 $0.75
H307 347-125 $1.50 $1.75 $1.50

When I run a query giving me profit analysis for
medicare, I get the results for all codes, but H306? All
my records look exactly the same as far as their common
field. My querie result looks like this:
Code NDC Bill_Unit Stan_Fee Pref_Cst Medicar_Allo
H305 534-456 1 $1 $0.20 $0.10
H306 265-458 5 $0.35
H307 347-125 4 $10 $1.50 $2.50

H306 is only included once on both tables and once in
crosstab query...It just does not want to pick up those
fields....

Please help.

Thank you.
-----Original Message-----
Not sure how you expect us to see your data? You are suggesting that your
data records aren't matching but we have no way of knowing what your values
are.

--
Duane Hookom
MS Access MVP


Hello:

I have report that will not calculate certain expression
for one record only...I went back to my querie from which
I created my report and the samething has happened...Do
you know why this happens? My querie is composed of 3
tables: preferred vendor, reimbursement, and fee
schedules summary...My reimbursement table is the one I
work from and link to the others....for whatever reason,
it is not picking up standard fee and medicare allowable
from my schedule summary also...The following is my
querie's SQL:

SELECT tbl_chemo_reimbursement_drugs.[2004 HCPCS],
qry_preferred_vendor_cost_final.NDC,
tbl_chemo_reimbursement_drugs.[2004 Billing Unit] AS
[BILLING UNIT], tbl_fee_schedules_summary_payers.
[STANDARD FEE], tbl_fee_schedules_summary_payers.MEDICARE
AS [MEDICARE ALLOWABLE], tbl_chemo_reimbursement_drugs.
[Vial Size], tbl_chemo_reimbursement_drugs.[Vial Unit],
qry_preferred_vendor_cost_final.[PREFERRED COST],
qry_preferred_vendor_cost_final![PREFERRED
COST]/tbl_chemo_reimbursement_drugs![Vial Size] AS [Cost
per mg], [2004 Billing Unit]*[Cost per mg] AS [Cost per
Billing Unit], [MEDICARE ALLOWABLE]-[Cost per Billing
Unit] AS Profit
FROM (tbl_chemo_reimbursement_drugs LEFT JOIN
tbl_fee_schedules_summary_payers ON
tbl_chemo_reimbursement_drugs.[2004 HCPCS] =
tbl_fee_schedules_summary_payers.[SERVICE CODE]) INNER
JOIN qry_preferred_vendor_cost_final ON
tbl_chemo_reimbursement_drugs.NDC =
qry_preferred_vendor_cost_final.NDC;

Thank you,

Luis
Click to expand...


.
Click to expand...
 
D

Duane Hookom

I'm sorry, I don't see how many of the number from your three tables get
displayed in final query. Where would I find the $1.00, $0.10, $10, $1.50,
and $2.50 in the values in the three tables?


--
Duane Hookom
MS Access MVP


Luis said:
I have three tables: fee schedules,reimbursement, and
preferred vendor...
Fee Schedules look:
Code Standard_Fees Medicare_Amount_Allowed
H305 $1 $0.10
H306 $4 $0.77
H307 $10 $2.50
Reimbursement Table:
Code NDC Billin Unit
H305 534-456 1
H306 265-458 5
H307 347-125 4
Preferred Vendor (Crosstab Query) looks:
Code NDC Preferred_Cost OSN_Cost TON_Cost
H305 534-456 $0.20 $0.20 $0.45
H306 265-458 $0.35 $0.35 $0.75
H307 347-125 $1.50 $1.75 $1.50

When I run a query giving me profit analysis for
medicare, I get the results for all codes, but H306? All
my records look exactly the same as far as their common
field. My querie result looks like this:
Code NDC Bill_Unit Stan_Fee Pref_Cst Medicar_Allo
H305 534-456 1 $1 $0.20 $0.10
H306 265-458 5 $0.35
H307 347-125 4 $10 $1.50 $2.50

H306 is only included once on both tables and once in
crosstab query...It just does not want to pick up those
fields....

Please help.

Thank you.
-----Original Message-----
Not sure how you expect us to see your data? You are suggesting that your
data records aren't matching but we have no way of knowing what your values
are.

--
Duane Hookom
MS Access MVP


Hello:

I have report that will not calculate certain expression
for one record only...I went back to my querie from which
I created my report and the samething has happened...Do
you know why this happens? My querie is composed of 3
tables: preferred vendor, reimbursement, and fee
schedules summary...My reimbursement table is the one I
work from and link to the others....for whatever reason,
it is not picking up standard fee and medicare allowable
from my schedule summary also...The following is my
querie's SQL:

SELECT tbl_chemo_reimbursement_drugs.[2004 HCPCS],
qry_preferred_vendor_cost_final.NDC,
tbl_chemo_reimbursement_drugs.[2004 Billing Unit] AS
[BILLING UNIT], tbl_fee_schedules_summary_payers.
[STANDARD FEE], tbl_fee_schedules_summary_payers.MEDICARE
AS [MEDICARE ALLOWABLE], tbl_chemo_reimbursement_drugs.
[Vial Size], tbl_chemo_reimbursement_drugs.[Vial Unit],
qry_preferred_vendor_cost_final.[PREFERRED COST],
qry_preferred_vendor_cost_final![PREFERRED
COST]/tbl_chemo_reimbursement_drugs![Vial Size] AS [Cost
per mg], [2004 Billing Unit]*[Cost per mg] AS [Cost per
Billing Unit], [MEDICARE ALLOWABLE]-[Cost per Billing
Unit] AS Profit
FROM (tbl_chemo_reimbursement_drugs LEFT JOIN
tbl_fee_schedules_summary_payers ON
tbl_chemo_reimbursement_drugs.[2004 HCPCS] =
tbl_fee_schedules_summary_payers.[SERVICE CODE]) INNER
JOIN qry_preferred_vendor_cost_final ON
tbl_chemo_reimbursement_drugs.NDC =
qry_preferred_vendor_cost_final.NDC;

Thank you,

Luis
Click to expand...


.
Click to expand...
Click to expand...
 
L

Luis

This is how they displayed in my final query:
Code NDC Bill_Unit Stan_Fee Pref_Cst Medicar_Allo
H305 534-456 1 $1 $0.20 $0.10
H306 265-458 5 $0.35
H307 347-125 4 $10 $1.50 $2.50
Click to expand...

H306 is missing Stan_Fee and Medicar_Allo...and I do not
understand why?

Thank you.
-----Original Message-----
I'm sorry, I don't see how many of the number from your three tables get
displayed in final query. Where would I find the $1.00, $0.10, $10, $1.50,
and $2.50 in the values in the three tables?


--
Duane Hookom
MS Access MVP


I have three tables: fee schedules,reimbursement, and
preferred vendor...
Fee Schedules look:
Code Standard_Fees Medicare_Amount_Allowed
H305 $1 $0.10
H306 $4 $0.77
H307 $10 $2.50
Reimbursement Table:
Code NDC Billin Unit
H305 534-456 1
H306 265-458 5
H307 347-125 4
Preferred Vendor (Crosstab Query) looks:
Code NDC Preferred_Cost OSN_Cost TON_Cost
H305 534-456 $0.20 $0.20 $0.45
H306 265-458 $0.35 $0.35 $0.75
H307 347-125 $1.50 $1.75 $1.50

When I run a query giving me profit analysis for
medicare, I get the results for all codes, but H306? All
my records look exactly the same as far as their common
field. My querie result looks like this:
Code NDC Bill_Unit Stan_Fee Pref_Cst Medicar_Allo
H305 534-456 1 $1 $0.20 $0.10
H306 265-458 5 $0.35
H307 347-125 4 $10 $1.50 $2.50

H306 is only included once on both tables and once in
crosstab query...It just does not want to pick up those
fields....

Please help.

Thank you.
-----Original Message-----
Not sure how you expect us to see your data? You are suggesting that your
data records aren't matching but we have no way of knowing what your values
are.

--
Duane Hookom
MS Access MVP


Hello:

I have report that will not calculate certain expression
for one record only...I went back to my querie from which
I created my report and the samething has happened...Do
you know why this happens? My querie is composed of 3
tables: preferred vendor, reimbursement, and fee
schedules summary...My reimbursement table is the one I
work from and link to the others....for whatever reason,
it is not picking up standard fee and medicare allowable
from my schedule summary also...The following is my
querie's SQL:

SELECT tbl_chemo_reimbursement_drugs.[2004 HCPCS],
qry_preferred_vendor_cost_final.NDC,
tbl_chemo_reimbursement_drugs.[2004 Billing Unit] AS
[BILLING UNIT], tbl_fee_schedules_summary_payers.
[STANDARD FEE], tbl_fee_schedules_summary_payers.MEDICARE
AS [MEDICARE ALLOWABLE], tbl_chemo_reimbursement_drugs.
[Vial Size], tbl_chemo_reimbursement_drugs.[Vial Unit],
qry_preferred_vendor_cost_final.[PREFERRED COST],
qry_preferred_vendor_cost_final![PREFERRED
COST]/tbl_chemo_reimbursement_drugs![Vial Size] AS [Cost
per mg], [2004 Billing Unit]*[Cost per mg] AS [Cost per
Billing Unit], [MEDICARE ALLOWABLE]-[Cost per Billing
Unit] AS Profit
FROM (tbl_chemo_reimbursement_drugs LEFT JOIN
tbl_fee_schedules_summary_payers ON
tbl_chemo_reimbursement_drugs.[2004 HCPCS] =
tbl_fee_schedules_summary_payers.[SERVICE CODE]) INNER
JOIN qry_preferred_vendor_cost_final ON
tbl_chemo_reimbursement_drugs.NDC =
qry_preferred_vendor_cost_final.NDC;

Thank you,

Luis


.
Click to expand...
Click to expand...


.
Click to expand...
 
D

Duane Hookom

I don't see where the other numbers are coming from so how can we tell why
H306 doesn't have numbers?

--
Duane Hookom
MS Access MVP


Luis said:
This is how they displayed in my final query:
Code NDC Bill_Unit Stan_Fee Pref_Cst Medicar_Allo
H305 534-456 1 $1 $0.20 $0.10
H306 265-458 5 $0.35
H307 347-125 4 $10 $1.50 $2.50
Click to expand...

H306 is missing Stan_Fee and Medicar_Allo...and I do not
understand why?

Thank you.
-----Original Message-----
I'm sorry, I don't see how many of the number from your three tables get
displayed in final query. Where would I find the $1.00, $0.10, $10, $1.50,
and $2.50 in the values in the three tables?


--
Duane Hookom
MS Access MVP


I have three tables: fee schedules,reimbursement, and
preferred vendor...
Fee Schedules look:
Code Standard_Fees Medicare_Amount_Allowed
H305 $1 $0.10
H306 $4 $0.77
H307 $10 $2.50
Reimbursement Table:
Code NDC Billin Unit
H305 534-456 1
H306 265-458 5
H307 347-125 4
Preferred Vendor (Crosstab Query) looks:
Code NDC Preferred_Cost OSN_Cost TON_Cost
H305 534-456 $0.20 $0.20 $0.45
H306 265-458 $0.35 $0.35 $0.75
H307 347-125 $1.50 $1.75 $1.50

When I run a query giving me profit analysis for
medicare, I get the results for all codes, but H306? All
my records look exactly the same as far as their common
field. My querie result looks like this:
Code NDC Bill_Unit Stan_Fee Pref_Cst Medicar_Allo
H305 534-456 1 $1 $0.20 $0.10
H306 265-458 5 $0.35
H307 347-125 4 $10 $1.50 $2.50

H306 is only included once on both tables and once in
crosstab query...It just does not want to pick up those
fields....

Please help.

Thank you.

-----Original Message-----
Not sure how you expect us to see your data? You are
suggesting that your
data records aren't matching but we have no way of
knowing what your values
are.

--
Duane Hookom
MS Access MVP


message
Hello:

I have report that will not calculate certain
expression
for one record only...I went back to my querie from
which
I created my report and the samething has happened...Do
you know why this happens? My querie is composed of 3
tables: preferred vendor, reimbursement, and fee
schedules summary...My reimbursement table is the one I
work from and link to the others....for whatever
reason,
it is not picking up standard fee and medicare
allowable
from my schedule summary also...The following is my
querie's SQL:

SELECT tbl_chemo_reimbursement_drugs.[2004 HCPCS],
qry_preferred_vendor_cost_final.NDC,
tbl_chemo_reimbursement_drugs.[2004 Billing Unit] AS
[BILLING UNIT], tbl_fee_schedules_summary_payers.
[STANDARD FEE],
tbl_fee_schedules_summary_payers.MEDICARE
AS [MEDICARE ALLOWABLE], tbl_chemo_reimbursement_drugs.
[Vial Size], tbl_chemo_reimbursement_drugs.[Vial Unit],
qry_preferred_vendor_cost_final.[PREFERRED COST],
qry_preferred_vendor_cost_final![PREFERRED
COST]/tbl_chemo_reimbursement_drugs![Vial Size] AS
[Cost
per mg], [2004 Billing Unit]*[Cost per mg] AS [Cost per
Billing Unit], [MEDICARE ALLOWABLE]-[Cost per Billing
Unit] AS Profit
FROM (tbl_chemo_reimbursement_drugs LEFT JOIN
tbl_fee_schedules_summary_payers ON
tbl_chemo_reimbursement_drugs.[2004 HCPCS] =
tbl_fee_schedules_summary_payers.[SERVICE CODE]) INNER
JOIN qry_preferred_vendor_cost_final ON
tbl_chemo_reimbursement_drugs.NDC =
qry_preferred_vendor_cost_final.NDC;

Thank you,

Luis


.
Click to expand...


.
Click to expand...
Click to expand...
 
L

Luis

It is coming from preferred vendor crosstab query shown
at the bottom...Is this what you need?
-----Original Message-----
I don't see where the other numbers are coming from so how can we tell why
H306 doesn't have numbers?

--
Duane Hookom
MS Access MVP


This is how they displayed in my final query:
Code NDC Bill_Unit Stan_Fee Pref_Cst Medicar_Allo
H305 534-456 1 $1 $0.20 $0.10
H306 265-458 5 $0.35
H307 347-125 4 $10 $1.50 $2.50
Click to expand...

H306 is missing Stan_Fee and Medicar_Allo...and I do not
understand why?

Thank you.
-----Original Message-----
I'm sorry, I don't see how many of the number from your three tables get
displayed in final query. Where would I find the $1.00, $0.10, $10, $1.50,
and $2.50 in the values in the three tables?


--
Duane Hookom
MS Access MVP


I have three tables: fee schedules,reimbursement, and
preferred vendor...
Fee Schedules look:
Code Standard_Fees Medicare_Amount_Allowed
H305 $1 $0.10
H306 $4 $0.77
H307 $10 $2.50
Reimbursement Table:
Code NDC Billin Unit
H305 534-456 1
H306 265-458 5
H307 347-125 4
Preferred Vendor (Crosstab Query) looks:
Code NDC Preferred_Cost OSN_Cost TON_Cost
H305 534-456 $0.20 $0.20 $0.45
H306 265-458 $0.35 $0.35 $0.75
H307 347-125 $1.50 $1.75 $1.50

When I run a query giving me profit analysis for
medicare, I get the results for all codes, but H306? All
my records look exactly the same as far as their common
field. My querie result looks like this:
Code NDC Bill_Unit Stan_Fee Pref_Cst Medicar_Allo
H305 534-456 1 $1 $0.20 $0.10
H306 265-458 5 $0.35
H307 347-125 4 $10 $1.50 $2.50

H306 is only included once on both tables and once in
crosstab query...It just does not want to pick up those
fields....

Please help.

Thank you.

-----Original Message-----
Not sure how you expect us to see your data? You are
suggesting that your
data records aren't matching but we have no way of
knowing what your values
are.

--
Duane Hookom
MS Access MVP


message
Hello:

I have report that will not calculate certain
expression
for one record only...I went back to my querie from
which
I created my report and the samething has happened...Do
you know why this happens? My querie is composed
Click to expand...
of
3
tables: preferred vendor, reimbursement, and fee
schedules summary...My reimbursement table is the one I
work from and link to the others....for whatever
reason,
it is not picking up standard fee and medicare
allowable
from my schedule summary also...The following is my
querie's SQL:

SELECT tbl_chemo_reimbursement_drugs.[2004 HCPCS],
qry_preferred_vendor_cost_final.NDC,
tbl_chemo_reimbursement_drugs.[2004 Billing Unit] AS
[BILLING UNIT], tbl_fee_schedules_summary_payers.
[STANDARD FEE],
tbl_fee_schedules_summary_payers.MEDICARE
AS [MEDICARE ALLOWABLE], tbl_chemo_reimbursement_drugs.
[Vial Size], tbl_chemo_reimbursement_drugs.[Vial Unit],
qry_preferred_vendor_cost_final.[PREFERRED COST],
qry_preferred_vendor_cost_final![PREFERRED
COST]/tbl_chemo_reimbursement_drugs![Vial Size] AS
[Cost
per mg], [2004 Billing Unit]*[Cost per mg] AS [Cost per
Billing Unit], [MEDICARE ALLOWABLE]-[Cost per Billing
Unit] AS Profit
FROM (tbl_chemo_reimbursement_drugs LEFT JOIN
tbl_fee_schedules_summary_payers ON
tbl_chemo_reimbursement_drugs.[2004 HCPCS] =
tbl_fee_schedules_summary_payers.[SERVICE CODE]) INNER
JOIN qry_preferred_vendor_cost_final ON
tbl_chemo_reimbursement_drugs.NDC =
qry_preferred_vendor_cost_final.NDC;

Thank you,

Luis


.



.
Click to expand...
Click to expand...


.
Click to expand...
 
D

Duane Hookom

No, that is not what I need. I would like to know how your table
records/values get transformed to the numbers displayed in your crosstab.

--
Duane Hookom
MS Access MVP
--

Luis said:
It is coming from preferred vendor crosstab query shown
at the bottom...Is this what you need?
-----Original Message-----
I don't see where the other numbers are coming from so how can we tell why
H306 doesn't have numbers?

--
Duane Hookom
MS Access MVP


This is how they displayed in my final query:
Code NDC Bill_Unit Stan_Fee Pref_Cst Medicar_Allo
H305 534-456 1 $1 $0.20 $0.10
H306 265-458 5 $0.35
H307 347-125 4 $10 $1.50 $2.50

H306 is missing Stan_Fee and Medicar_Allo...and I do not
understand why?

Thank you.
-----Original Message-----
I'm sorry, I don't see how many of the number from your
three tables get
displayed in final query. Where would I find the $1.00,
$0.10, $10, $1.50,
and $2.50 in the values in the three tables?


--
Duane Hookom
MS Access MVP


message
I have three tables: fee schedules,reimbursement, and
preferred vendor...
Fee Schedules look:
Code Standard_Fees Medicare_Amount_Allowed
H305 $1 $0.10
H306 $4 $0.77
H307 $10 $2.50
Reimbursement Table:
Code NDC Billin Unit
H305 534-456 1
H306 265-458 5
H307 347-125 4
Preferred Vendor (Crosstab Query) looks:
Code NDC Preferred_Cost OSN_Cost TON_Cost
H305 534-456 $0.20 $0.20 $0.45
H306 265-458 $0.35 $0.35 $0.75
H307 347-125 $1.50 $1.75 $1.50

When I run a query giving me profit analysis for
medicare, I get the results for all codes, but H306?
All
my records look exactly the same as far as their common
field. My querie result looks like this:
Code NDC Bill_Unit Stan_Fee Pref_Cst
Medicar_Allo
H305 534-456 1 $1 $0.20 $0.10
H306 265-458 5 $0.35
H307 347-125 4 $10 $1.50 $2.50

H306 is only included once on both tables and once in
crosstab query...It just does not want to pick up those
fields....

Please help.

Thank you.

-----Original Message-----
Not sure how you expect us to see your data? You are
suggesting that your
data records aren't matching but we have no way of
knowing what your values
are.

--
Duane Hookom
MS Access MVP


message
Hello:

I have report that will not calculate certain
expression
for one record only...I went back to my querie from
which
I created my report and the samething has
happened...Do
you know why this happens? My querie is composed of
3
tables: preferred vendor, reimbursement, and fee
schedules summary...My reimbursement table is the
one I
work from and link to the others....for whatever
reason,
it is not picking up standard fee and medicare
allowable
from my schedule summary also...The following is my
querie's SQL:

SELECT tbl_chemo_reimbursement_drugs.[2004 HCPCS],
qry_preferred_vendor_cost_final.NDC,
tbl_chemo_reimbursement_drugs.[2004 Billing Unit] AS
[BILLING UNIT], tbl_fee_schedules_summary_payers.
[STANDARD FEE],
tbl_fee_schedules_summary_payers.MEDICARE
AS [MEDICARE ALLOWABLE],
tbl_chemo_reimbursement_drugs.
[Vial Size], tbl_chemo_reimbursement_drugs.[Vial
Unit],
qry_preferred_vendor_cost_final.[PREFERRED COST],
qry_preferred_vendor_cost_final![PREFERRED
COST]/tbl_chemo_reimbursement_drugs![Vial Size] AS
[Cost
per mg], [2004 Billing Unit]*[Cost per mg] AS [Cost
per
Billing Unit], [MEDICARE ALLOWABLE]-[Cost per Billing
Unit] AS Profit
FROM (tbl_chemo_reimbursement_drugs LEFT JOIN
tbl_fee_schedules_summary_payers ON
tbl_chemo_reimbursement_drugs.[2004 HCPCS] =
tbl_fee_schedules_summary_payers.[SERVICE CODE])
INNER
JOIN qry_preferred_vendor_cost_final ON
tbl_chemo_reimbursement_drugs.NDC =
qry_preferred_vendor_cost_final.NDC;

Thank you,

Luis


.



.
Click to expand...


.
Click to expand...
Click to expand...
 
L

Luis

It must be my lucky night...All I had to do is retype the
exact same thing for the specific record I was having
problems...Thank you again for your help...this helps me
complete my database...

One more question, now that I have set up my database, I
have a profit & loss analysis for each insurance in the
market-we have about 10 of them, in which I have created
a separate query for each insurance...I want to make it
simple and rather than put it in 10 different queries, I
want to be able to type the insurance and have the query
generate me the profit and loss report...How can I
combine them? What is my best approach.

Thank you,

Luis
-----Original Message-----
No, that is not what I need. I would like to know how your table
records/values get transformed to the numbers displayed in your crosstab.

--
Duane Hookom
MS Access MVP
--

It is coming from preferred vendor crosstab query shown
at the bottom...Is this what you need?
-----Original Message-----
I don't see where the other numbers are coming from so how can we tell why
H306 doesn't have numbers?

--
Duane Hookom
MS Access MVP


This is how they displayed in my final query:
Code NDC Bill_Unit Stan_Fee Pref_Cst Medicar_Allo
H305 534-456 1 $1 $0.20 $0.10
H306 265-458 5 $0.35
H307 347-125 4 $10 $1.50 $2.50

H306 is missing Stan_Fee and Medicar_Allo...and I do not
understand why?

Thank you.
-----Original Message-----
I'm sorry, I don't see how many of the number from your
three tables get
displayed in final query. Where would I find the $1.00,
$0.10, $10, $1.50,
and $2.50 in the values in the three tables?


--
Duane Hookom
MS Access MVP


message
I have three tables: fee schedules,reimbursement, and
preferred vendor...
Fee Schedules look:
Code Standard_Fees Medicare_Amount_Allowed
H305 $1 $0.10
H306 $4 $0.77
H307 $10 $2.50
Reimbursement Table:
Code NDC Billin Unit
H305 534-456 1
H306 265-458 5
H307 347-125 4
Preferred Vendor (Crosstab Query) looks:
Code NDC Preferred_Cost OSN_Cost TON_Cost
H305 534-456 $0.20 $0.20 $0.45
H306 265-458 $0.35 $0.35 $0.75
H307 347-125 $1.50 $1.75 $1.50

When I run a query giving me profit analysis for
medicare, I get the results for all codes, but H306?
All
my records look exactly the same as far as their common
field. My querie result looks like this:
Code NDC Bill_Unit Stan_Fee Pref_Cst
Medicar_Allo
H305 534-456 1 $1 $0.20 $0.10
H306 265-458 5 $0.35
H307 347-125 4 $10 $1.50 $2.50

H306 is only included once on both tables and once in
crosstab query...It just does not want to pick up those
fields....

Please help.

Thank you.

-----Original Message-----
Not sure how you expect us to see your data? You are
suggesting that your
data records aren't matching but we have no way of
knowing what your values
are.

--
Duane Hookom
MS Access MVP


message
Hello:

I have report that will not calculate certain
expression
for one record only...I went back to my querie from
which
I created my report and the samething has
happened...Do
you know why this happens? My querie is composed of
3
tables: preferred vendor, reimbursement, and fee
schedules summary...My reimbursement table is the
one I
work from and link to the others....for whatever
reason,
it is not picking up standard fee and medicare
allowable
from my schedule summary also...The following is my
querie's SQL:

SELECT tbl_chemo_reimbursement_drugs.[2004 HCPCS],
qry_preferred_vendor_cost_final.NDC,
tbl_chemo_reimbursement_drugs.[2004 Billing Unit] AS
[BILLING UNIT], tbl_fee_schedules_summary_payers.
[STANDARD FEE],
tbl_fee_schedules_summary_payers.MEDICARE
AS [MEDICARE ALLOWABLE],
tbl_chemo_reimbursement_drugs.
[Vial Size], tbl_chemo_reimbursement_drugs.[Vial
Unit],
qry_preferred_vendor_cost_final.[PREFERRED COST],
qry_preferred_vendor_cost_final![PREFERRED
COST]/tbl_chemo_reimbursement_drugs![Vial Size] AS
[Cost
per mg], [2004 Billing Unit]*[Cost per mg] AS [Cost
per
Billing Unit], [MEDICARE ALLOWABLE]-[Cost per Billing
Unit] AS Profit
FROM (tbl_chemo_reimbursement_drugs LEFT JOIN
tbl_fee_schedules_summary_payers ON
tbl_chemo_reimbursement_drugs.[2004 HCPCS] =
tbl_fee_schedules_summary_payers.[SERVICE CODE])
INNER
JOIN qry_preferred_vendor_cost_final ON
tbl_chemo_reimbursement_drugs.NDC =
qry_preferred_vendor_cost_final.NDC;

Thank you,

Luis


.



.



.
Click to expand...
Click to expand...


.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Records 3
Access Report Multiple Calculations and Grouping 2
Report and Group Totals 2
Grouping and Sums issue (do it w/ Query or Report?) 1
Crosstab query with criteria, dynamic columns and crosstab report question 5
AMD R600 Architecture and GPU Analysis (long read) 5
History of Xbox 360 defects - Dean Takahashi has the inside story(long) 2
Download the JAVA , .NET and SQL Server interview with answers 2

Top