Search results for query: *

I have a report that I am trying to use to receive total charges on NitricGas that we use. The patient can only be charged a max of $12,000.00 within a 30 day period. They may have a $9,750.00 charge on one day and a $10,625.00 charge on another day within that 30 day limit but in my report I...

I deleted a formula from my report and even tho I have done this it still says it is being used in the report and will not allow me to refresh my report. I know that the formula has been deleted and it is no longer in the report. When I go to insert the fields and go under formulas there is...

if time({table.field}) >= time(7,30,0) and time({table.field}) < time(19,0,0) then "Shift 1" else "Shift 2" I am getting an error that says a ) is missing. I have double checked and can not find where to put the paren. Any suggestions? Thank you,

We operate on a 24X7 hour time range. I need to do a report that will allow me to capture the time range for my 2nd shift people. The time will be 7Pm to 7:30AM This allows me to do a productivity report. I have a report set up and it is getting my information for the dayshift just fine but the...

I have two tables TableInfo and UseageLog the Useage log has start date and time. On my form a patient may have several Start Date and times. I want to take the current date and time meaning the time that I open up my form and subtract the earliest start date and time. Then if it totals to 96...

I have a formula that goes like this: if {Tank_Log.Total Charges per Inometer}>12000 then 12000 I want to add to that formula that if it is less than 12000 then let the original amount show. What do I need to add to this?? Thanks! Gizmo

I need to create a Date formula so that I can use to pull up the right data in my report. I am trying to pull up a report that has a date field in for a report we will call &quot;ProdMonthly Total Report&quot; for Jan 1 2004 -Jan31 2004. The report has the follwoing fields: Date Prod 1 Prod 2...

Okay I am using a canned report that I have saved and renamed so I can make changes to it. The report gives me the following information: Missed Treatment info Date and Time Patient Name Case Number Work Area I am only interested in getting the Workarea for those areas related to Pediatrics...

I have a date field for Employee BDays I would like to group them in a report by Month and day only. But since the year is included when I try to group by Month it groups it by month but also by year. How can I get it to ignore the year and just group it by the Month and Day only? I tried to...

I am creating a report that I would like to use a LName,FName Combo as a Parameter. However in the original table it has the LName and FName as separate fields. So when I try to import the information into the Param Field it is impossible to import the info as a name field combined. I have...

I have a report. I created to Formula Fields SDate (Feeding off ChartDate) and EDate (Feeding off ChartDate); I would like to have my report ask the user to enter a date range using these to formula fields so I know that it is pulling from the correct date fields. How do I do this? I used to...

I have 2 tables Table 1 LabID (This is a number that designates what type of lab it is depending on the number)this is the primary key LabNam (this is the Name of the LAB) Table 2 LabNum (this is the same # as LabID and links the two tables) TypeLoc (loc num such as 10N(trauma) which tells...