Search results for query: *

In the SQL below of my query A, qryIncident Master File, the field “[DOIYear]” is formatted as “yyyy” to give me the correct Year. I want another query B to sum the total number of incidents grouped by Year, [DOIYear]. I can’t get the grouped query to work properly; it will group the year and...

I have a Popup Switchboard and when I press the menu buttons for reports, the reports come in view, however the report displays in the background while the Switchboard remains in front. If I press other buttons on the Switchboard referring to other reports, those reports always display in the...

The below coding was graciously provided by OnTheFly and PHV. As I open “frmList of Individuals” which has a subform “frmAppointments”, I press the cmdPrint Current Record, it prints the selected “rptAppointment Letter” using the [ApptID] field, then closes “frmList of Individuals”. This works...

I have the main “frmList of Individuals” which has a subform “frmAppointments” which consists of several scheduled appointments. The Primary Key in the “frmList of Individuals” is [ClientID#] and the two Primary Keys in “frmAppointments” are [ClientID#] and [ApptID#]. I have a Command Button...

I am looking for a way to display 2 fields of data that have multiple listings in “columns” in a report. Example: I want to send in a letter to my clients a listing of 320 destinations that come from 2 fields; [Destination] and [Category]. Normally the first 40 or so names appear on the first...

I have a field that lists the last name, first name, middle or middle initial with a period all in one cell, Examples Given: Lager, Curtis A. Lager, Curtis Adrian Lager, Sr, Curtis A. Lager Curtis Adrian, Sr. The staff is not consistent except for the last name. I want to create a query that...

My database is opened via a password and then the Switchboard is in view. Prior to entering any of the menus and as the database opens, I would like to have a PopUp dialog box appear. This PopUp box will provide a warning statement, which has to be read, and then press the “close” button on...

I am using Microsoft Office Access 2003. Does Microsoft Access have the capability of using a dual password entry? I have a current database that has a single password and when used, the main switchboard opens. The main switchboard has several sub-switchboards. Currently, the database is set...

In my “tblTime Survey Data”, I have 5 series of Time Events; which are formatted as Short Time: 00:00;0;: for input mask. The first query A: “qryTime Survey Data w Time Difference”, lists the “time differences” between the time events. IE: The first two time events: TA and TofT are 07:00...

I’m looking for a Sample database if possible, a an “Appointment Scheduler”. I know there are some commercial products available, however we can’t use a third party commercial software product and without Microsoft Outlook. I was going to build one, however I thought as an alternate avenue to...

I have 5 option groups in my Demographics part of the database in which I want to display the choices selected, in “text” format in a report. I have trouble writing my query to display the text. From the tblMain Data Table, [Gender] has the three choices: 1 Male, 2 Female and 3 Left Blank (3...

I have a table with 3619 records consisting of Individuals whom have donated [DateDonated]; some individuals have multiple donations, ranging from 1 to 9 donations, with 9 the most donations. I want to display a single record of the individual and his/her donation dates; listing from left to...

I am looking for an appropriate formula in my Report to have the field [PRptDays] which is “a # of days”, displayed in Red if the field [PRptDays] has expired from the [DateOfExam] field. For example: The [DateOfExam] was 10/30/03 and the individual had 90 days [PRptDays] to gather his/her...

I have two fields that I need PDMS and PDDNMS. In the 1st field, if either the Police or Driver is checked AND if FRMS is also checked, then I need a 1; the same for the 2nd field, except if FRDNMS is checked then I need a 1. However, in both statements, the results display additional records...

In the following portion of my SQL, I am having a problem in getting the appropriate results. If [PEPolice]=True, I want the job title to be "Police" and if [PEDriver]=True, then I want the job title to be Drivers. This part displays the appropriate results. However, if neither are true, then...

1. I have 3 Job Titles: [PEPolice1], [PEDriver1] and [PSWSP1]. 2. The 2 “Meets/Does Not Standards”: [FRMS1] and [FRDNMS1] apply only to the Police and Driver. 3. The [PSWSP1] may have only 4 of the 8 “Other Standards”...

My goal is to be able to calculate # of days between several dates. I know how to calculate # days, however it is setting up the query so that the [DateOfExam]s are displayed from left to right on the same row as the matching [SSN] and [Name]. I have a query that found duplicate records. My...

My goal is to have the [Job#] field in my query to display the number 240 if the field [Job] is blank, OR if the number is 0. In my query I have the following formula which works for blank data entries. However, I can not get those [Job] fields with a 0 to be converted to the number 240. I...

I am seeking help with a Conditional Formatting issue. I want the [VisitDate]field in my report I want to display a "yellow back filled" where there are no entries, that is when the field as no data in it. For the "Conditional 1, I selected "Expression Is". Then I inserted...

I have three fields in my report that I am having a problem in trying to format them in a “currency format with color”. The report source is a query using the Switch function. Currently the figures are displayed as 20 for $20.00 or just 23.25 for $23.25. I want the three different colors, one...