jennwilson
Last Activity: Dec 3 '07, 03:07 PM
Joined: Feb 1 '07
Location: Maryland
-
I figured out the issue. I didn't have the two ID Fields joined in the actual query. I only joined them in the table. The query is working fine now. -
I still need help with this issue.
As I am looking at the returned results more closely it is returning different information for the rates that are retrieved from clinician table. One individual doesn't even have rates listed in her record and in the 166 duplicate records returned it is showing various rates. Figuring that it is pulling it from the Clinician table, I must have something connected wrong, but don't know what....Leave a comment:
-
After reading my initial posed questio.... I am left thinking you all have know idea what I am asking.
This is the problem ---- The query I built of which the code is listed above is running without any error messages, but it is returning the same exact record umpteen hundred times. I tried to change the group by and it is now returning 20 or so of the same exact record for the same date, same clinician when I run the query. I know...Leave a comment:
-
Per Billable Log.ProviderID joined to Clinician.ID
Does that answer your question?Leave a comment:
-
Query returning duplicate records
Using Access 2000 - I have a query that is suppose to return the records from table [ Per Billable Log] within specified time range and find matching data from another table [ Clinician].
Table [Clinicians] houses Clinician name, location and rate information
Table [Per Billable Log] houses Clinician name, location and number of units for each type of service rendered on each day. The two tables are connected by field [ID]... -
THANKS so much. This is the first time I have had a chance to get back online after my original post. The fix worked great. Thanks!...Leave a comment:
-
Date Query on two date fields in the same query
I am trying to generate a report based on a query that will list any records where an individual has a date listed that matches the specified time for one or both of the date fields. The two fields are danpdate and testdate.
...Code:SELECT PatientDemo.PatientType, PatientDemo.ClinicianName, PatientDemo.ClientName, PatientDemo.DOB, PatientDemo.FacilityName, PatientDemo.PrimaryInsurance, PatientDemo.SecondaryInsurance, PatientDemo.TertiaryInsurance,
-
Need to manipulate data:
The data would not need to be manipulated. It just needs to be sent within an excel file due to additional information that is sent in excel. For ease of transitioning a "new" way to process information, I was hoping to have the report go directly into the area where individuals would normally spend type retyping/entering the same patient demographic information on sheet 2 of the workbook. If that makes...Leave a comment:
-
Exporting Report to Excel and have it look like a pdf.
Access 2000 - I have developed a database that houses patient information. The patient information must be sent in an excel file to another company department. I know how to export my data to Excel where it ends up in individual cells (Rows/Colums, etc). I would like for the report that I am exporting to Excel to transfer like a pdf. file. and be similar to the report generated in the database. Kind of like a snapshot of the report, is this possible?... -
*Pulling out hair*
First, thank you so much for all of your help with the SQL writing. It worked and I did a huge happy dance. The happiness ended when I came to work and found out that there was a change from yesterday and now I need to subtract from the [sumexpected] the points assigned to [PTOPoint] and [AdminPoint]. I attempted to add this function in the design view of my query and I am back to receiving the subquery error....Leave a comment:
-
Ok - In hopes of reducing the number of calculations that need to be done in the query, I reduced the number of fields in my table. I am going to list the fields in the table, list the fields and their functions for the query, the current SQL for the query, and hopefully this will help :? Sorry for the change.
Table . SERVICELOG
ID - Primary Key
Clinician - text field
Location - text field
Date...Leave a comment:
-
Thank you for your help. It is still not right. For the last query given, I have errors for values and it is showing each individual record rather than giving me one grand total for all records during the specified date range.
Should I paste my Table?Leave a comment:
-
I created the query in the design view. Due to my lack of experience and knowledge with SQL, I am not sure why it says DISTINCTROW. Sorry :(
I have expected and sum of expected for the following reasons:
I need the actual expected that remains constant for the clinician to calculate a...if less than... use expected..expre ssion in field [calc]. I need the sum of expected which totals the expected less the nonwork...Leave a comment:
-
SELECT DISTINCTROW Log.Clinician, Log.Location, Log.Expected, Sum([Expected]-Log![Non Work Day Expected]) AS SumExpected, Sum(Log!DOMHA+L og!DOCS+Log!EAP +Log![NRP Points]) AS SumEarned, Sum(Log.PTO) AS SumPTO, Avg(Log!DOMHA+L og!DOCS+Log!EAP +Log![NRP Points]) AS AvgEarn, IIf([AvgEarn]>[Expected],[Expected],[AvgEarn]) AS Calc, [Calc]*[SumPTO] AS PTOPoint, Sum(Log!Admin) AS SumAdmin, [SumAdmin]*[Calc] AS AdminPoint, [SumEarned]+[PTOPoint]+[AdminPoint]...Leave a comment:
-
Counting particular Record in a Query
Ok - So, I am back.
I would like to count the number of times a specific record appears in a field from one table in my query and then use that value in the same query to calculate an average. I am using Access 2000 and am still learning.
Background info:
Overall, I am creating a database to track and calculate data regarding employee productivity. For each scheduled day, employees have a set... -
The issue is closed. I do have another problem regarding counting a data in a field that is of a certain value ... but I am looking through previous posts to hopefully solve the problem first. If not, I'll be a repeat customer!!
Thanks again!...Leave a comment:
-
Thank you Thank you Thank you!!!!!!! with extra chocolate sauce and everything else good in this world!
I am all set now and ready to conquer the task at hand. Once again, thanks for your help you have been a life saver... or well at least a job saver!!!
Thanks again!Leave a comment:
-
Thank you for your assistance. In the field, as suggested, I typed in the following:
Points: IIf([AvgEarn]>[log]![Expected],[Log]![Expected],[AvgEarn])
Total: I selected Expression, tried the Total field blank and selected others. Each time, I received the following error:
You tried to execute a query that does not include the specified expression 'IIf(/ >[log]![Expected],[Log]![Expected],[AvgEarn])'...Leave a comment:
-
Help with Query ... If greater then insert... Syntax Error
I am a somewhat Novice Access user and have limited rather zilch programming skills.
Problem:
I am receiving the following error: "The expression you entered contains invalid syntax'
In the query, I have built several fields containing calculations. In one of the fileds, I am trying to have the field insert one value, if the current value is greater than the other value. For example - if AvgEarn...
No activity results to display
Leave a comment: