Search results

Hi All, I am struggle a bit here and need your guidance on how to accomplish what I described in the title: I have 3 tables: tbl_activities - contains a list of activities tbl_districts - contains a list of districts tbl_districtactivities - This is the district transaction that shows a list...

Hi All, I have a very complicated (for me) query. I am working on a blood sugar calculations and have the following under Screening Type: FBS, PPBS, HgA1C. A patient can have any of the 3 screenings. Here is how my query is setup...

I am having difficulties setting a criteria in DLookup. How do I setup the Dlookup criteria to get the result if date of service = MinDOV? Let's say i have the following table PatientID--DateofVisit--ScreeningType--Result 1234--01/01/2011--LDL--140 if MinDate =DateofVisit it should give me...

I have a database that keeps track of each visit with the following columns - ID - ClientID - VisitDate - Type - Value So what I am trying to do is find out the following: - Client's first visit - Client's last visit - The number of weeks between the first and last visit - The number of weeks...

Hi All, How do I calculate a record by group? I have 3 groups in my report: - ActivityDate - FunctionsID - EmployeeID I want to calculate how many records are in the employeeID. Also, is there a way to number the employees? (let's say i have 7 employees, and i want each employee to have a...

Hi All, I recently upgraded to a SQL server backend. After the upgrade, i was able to add/update a particular table but now i can't seem to do anything. This is only happening for 1 table. However, I am able to add/update from the tables in SQL server directly. what could possibly be the...

Hi All, I am having some problems hiding the results from a duplicate query. what happens is that I find all of the duplicates using the find duplicate query, but it counts it twice as it shows all duplicate items. how can i re-write the query below to only show the duplicated entries once...

Help with Calculated Report Hello All, I have been tackling this issue for so long. I have a report that gives me the average team performance per function. Another report that gives me Individual performance per Function. What I want to do is show the individual's performance against the...

Good Afternoon All, I am currently working on a database that creates a letter based on the user's input. The problem I am currently having is that I can't seem to have 2 or more Reasons without duplicating the entire record. My workaround to show 2 or more reasons is to duplicate the entire...

Good Afternoon All, I am having a problem with my IIF Statement below: =IIf(IsNull([txtStandard]),"None",IIf([txtitemsperhour]>[txtstandard],"Exceeds Expectations",IIf([txtitemsperhour]<[txtstandard],"Below Expectations",IIf([txtitemsperhour]=[txtstandard],"Meets Expectations")))) What I want...

Hello All, I have recently installed MS SQL Server 2005 Express into my WinXP system w/ SP2 installed. It successfully installed and I was able to create a database but now my problem is that it is restricted to my local computer. Therefore, user's in my network are not able to view my...

Good Afternoon All, I am having a bit of a trouble looking for a way to link to tables. Let's say I have table1 and table2 Both tables have the 50 U.S. States. The reason i have them named differently is because the 2 tables have different sources with thousands of records. table1 - State...

Hello All, I just got a SQL Server installed but for some reason it's not allowing me to create a new database. The New database button is grayed out under the SQL Server Enterprise Manager. Does anyone know what seem to be the problem here? Thank you,

Hi All, I have built a report based on the following query: SELECT tblDailyActivities.ActivityDate, tblDailyActivities.EmployeeID, tblDailyActivities.StartTime, tblDailyActivities.EndTime, tblDailyActivities.Description, tblDailyActivities.Quantity, tblDailyActivities.FunctionsID...

Hello All, I am trying to get the code below to search for dates but i can't seem to get it right, I know we have to include # before and after the date but i am not sure where to place it in the code. The code below search for the minimum and maximum number of days. ' Check for Minimum...

Hi Everyone, I recently found out that access does not handle memo fields very well and it corrupts the database. My database users inputs plenty of notes in the memo field and my DB corrupts quiet often. Would the upgrade to the SQL server fix this issue? Thank you,

Hi All, I have searched the forum but i could not find the answer I was looking for. My database keeps corrupting and it's only been happening recently when user's started populating their memo box. I have noticed that it doesn't get corrupted when they are typing their notes in the memo box...

Good Evening Everyone, I am having a problem getting this code below to work Private Sub btnAdminTools_Click() On Error GoTo Err_btnAdminTools_Click If admin = True _ Then Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmallinonereport" DoCmd.OpenForm...

Hello All, I have a report that shows the individual stats as well as the individual stats compared to other members. What I would like to do is to separate their total time by Production and Non-Production. I get the total of both production and nonproduction by:=Sum([TotalTime]) To...

Hello All, Database Use I seem to have a never ending obstacles in my project. What I am building is a timing database that measures the amount of time an employee spends on Functions. I have about 50 functions available but these functions are spread out to individuals. Progress What I have...