Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: KayJen
  • Content: Threads
  • Order by date
  1. KayJen

    Need date to change at start of a new year.

    I have a database to track employee evaluations on a year to year basis. The month and day are always the same, however, the year changes, or should hence this is where the problem lies. For instance in December 2003, I would like to send out a letter to all supervisors stating what...
  2. KayJen

    Two diffferent items in On Current, but How?

    I have a form that I am using and in the On Current Event I have it looking for and loading any photographs as the example shows below. I'm also trying to make a command button visible if a certain criteria is met. Is it possible to load more than one event in the On Current portion. Any help...
  3. KayJen

    Birthdate and Null Equals Error

    Hi, I have a field labeled BirthDate on a Form labeled frm_Clients. Next to the Birthdate field is an unbound boxed labeled Age with the following in the Control Source: =Age([BirthDate]). Now to my problem. I also have and unbound box titled: Status, with the following in the Control Source...
  4. KayJen

    Past Help almost working, Just a little most assistance

    I am working on an accident program where the streets can be entered as A and B or as B and A, (beyond my control comes from accident investigators), I have the query working up to this point to count them, however, they are now listed twice, please help one more time with this ever present...
  5. KayJen

    Can A+B also count B+A as one

    Can I use a query to count how many times a set of streets appear in a database. Main Street and Center Street = 4 Center Street and Main Street = 1 These are the same so I would like the count to be 5, but I can't get this to work. My Table is Accidents with the below fields BaseStreet...
  6. KayJen

    Query Results Come Up Short

    I am working on an Accident Collision Program, which requires tracking accidents that occur in an intersection as well as those that occur between two streets in other words Mid Block Accidents. I have three streets, Base Street, Collision Street and Toward Street when I run a query to count...
  7. KayJen

    Four Combo Boxes to One Unbound Text Box

    I currently have four combo boxes to fill in one unbound text box. The information used to fill in theses boxes comes from a written report, however I can't control in what format it will be written. There are 5,000 primary names and some of these names might have secondary and/or third...
  8. KayJen

    Multiple ComboBoxes

    I am tracking traffic accidents using a form and several combo boxes, here is my current method: I have a table with all streets in the city listed, however, some not only have a proper name but they also have a county number and/or state number, which means a police officer might use any of...
  9. KayJen

    Chart by Numeric Quarter not Text

    Hi, I have a query that gathers all necessary data and prints to a chart just fine. My problem is everyone wants the chart to say First, Second, and so on instead of 1, 2 Quarter of (Current Year). I've played with the query and have an IIF statement, this works, however I get multiply...
  10. KayJen

    DCount always = 0

    I have a form called Interview. When I enter a social security number in the text box named SSAN, I would like for an adjacent unbound text box currently named SSAN_TST to count how many times the social security number appears in the database. I have a query named CountSSN which counts the SSN...
  11. KayJen

    My calendar form is almost automated except for, What?

    The below command button works until the report is called at which time the query parameter is missing from the report, however, if I type the dates in and by-pass the button, the parameters are displayed on the report. Please help... This routine is activated after I select a start and end...
  12. KayJen

    Counting multiple items with name variants

    I have the following query attached to a form which works fine. Like "*" & [Forms]![QBF_Items]![WhatItems] & "*" However, I would like to have another query which will count the items found by this query. Here is where the problem lies. The above query will find all items...
  13. KayJen

    Calculation close and Yet Not

    I have a query that groups and counts the crimes by the parameters have previously set in another query. When the field is empty, (good thing no crime) I used the following IIf statement to give me 100%: Percent:IIf([Total Of Crime Types1]>0,Format([Change]/[Total Of Crime...
  14. KayJen

    Calculation close and Yet Not

    I have a query that groups and counts the crimes by the parameters have previously set in another query. When the field is empty, (good thing no crime) I used the following IIf statement to give me 100%: Percent:IIf([Total Of Crime Types1]>0,Format([Change]/[Total Of Crime...
  15. KayJen

    Counting Complaints made?

    My department as requested that I keep track of complaints against employees. The manager wants to enter the employees social security number and an unbound box will indicate the number of previous complaints. I can do this with a query, but have been unable to display the information on the...

Part and Inventory Search

Back
Top