Search results for query: *

I have several clients that remote into a terminal services server and have been for about 2 years. They log into their own separate databases. Everything has been working fine, but today out of the blue, the reports screen doesn't work with any clients sep. database. When they click on a...

I have a data entry form using a lookup query (datasheet view) to where they enter the employee id and it pulls the name and payrate automatically. Then they enter the number of minutes in the appropriate fields. However, it doesn't save the name or payrate into the table. It only displays...

I have a query that produces this: Name HomePhone BusinessPhone MobilePhone Angie 555-5555 Angie 333-3333 Angie 222-2222 I need it to combine into one line in the query like this Name HomePHone BusinessPhone MobilePhone...

Stamps.com has taken over the insert autotext section. Inserting header or footer shows only stamps.com options. How do I get rid of this. I have uninstalled stamps.com and also reinstalled word and it is still showing up. I have also looked at the addins within word and I don't see it...

I have a query to where I added a column called visits. I need it to place a 1 in the visits column. The trick is, I can only have a 1 per day per patient for the same disc. How do I have it place a one on the first record of the group. I hope this example helps show you what I need. I need...

I have a report that I generated that will list each day and the day of the week. I have a footer for week showing up at the end of the week and tells me the number of overtime hours. Works Perfect! Now, I need help! Our payroll works in a different way. We are paid for the 1st through...

I have another linking field issue. This does not involve calculations. I have a data entry query to speed up the process. When they enter the facility number, the facility name automatically pops up in the next field labeled facility name. What I need is for the facility name to go with the...

I have three fields on my data entry form: AMinutes BMinutes TxMinutes I have the txminutes field automatically add the aminutes and the bminutes together as they enter the data so that they can see the total immediately. I want the result from the txminutes field to be permanent in the...

I have a report that looks like this: Day Facility Hours 1 Four Seasons 3.5 1 Greencroft 2 2 Four Seasons 4 3 Nazareth 2 3 Greencroft 4 I want a grand total at the bottom of the report to show a break out with totals. Example: Four Seasons...

I have a query that pulls total minutes by payor type. It looks like this: Day# PartA PartB Other 1 65 1 20 1 36 How do I make this one line with the totals, example Day# PartA PartB Other 1 65 36...

I have three fields called MONTH, DAY, and YEAR they are all in number format, example: MONTH DAY YEAR 1 7 2005 In my query I have created a field called Date of Treatment and combined the three above fields to form my date. The expression is [Month] & [Day] & [Year] This...

I have a data entry form that is setup as a datasheet view. Works perfect. The problem is now they want is dummy proof. Here is what the datasheet view looks like. Month Day Year CPT DirectMinutes Units 8 1 2004 97001 10 1 8 1 2004 97110...

I have a medical service log report that is working great. I just added some additional totals at the bottom and it is telling me that I have too many fields defined when I am trying to run the report. I am so close in being done with this whole project and I didn't expect this to be a...

Can this be done in access and how would I start. We are a healthcare company and want to create a documentation form. We would like them to have a drop down of predefined sentences, that when they click on the sentence they want, it adds it to the textbox that they are typing the note...

I have a report calculation problem. I have this formula at the bottom of the report! =Sum(IIf([PayorType]<>"a",[Units_Crosstab_2],"0")) It works great, however, I really want it to place a zero in the field when it does equal "a". It works fine except for it just leaves the field blank...

I have a cross tab query that pulls minutes per day. I also have a cross tab query that pulls units per day. I combined the two with a standard query that pulls minutes and units together on the correct day. I have been very pleased with the results on the query and report until I came across...

I have a report, when I run it, it asks me for Month, Beginning Day, Ending Day, Year. Then it prints all of my results for me just fine. My current report header shows the Month and Year for the report printed. They want to see the Beginning Day and the Ending Day on the report header so...

I have run several virus removal tools and scanned the computer for viruses, didn't find any. I can't open anything at all. When I try to go to the control panel, same thing. The error message that I receive is: You do not have permission to access the program/folder. I am running Windows...

I can't seem to find an answer to this, seems simple to me but I am a beginner. I have a very simple table, query, and report. I need to create a service log that should look like this. I do have it grouped by CPT code. The report should look like this; CPT Code Day 1 2 3 4...

Okay, I am a beginner and I will try to explain this. I already have my basic fields set up and my query as well. This is what I want my report to look like! Day# CPT Description 1 2 3 4 5 6 7 971 Eval 5 2 0 1 1...