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 TouchToneTommy 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: burcher
  • Content: Threads
  • Order by date
  1. burcher

    DCount Update

    I have a table that has multiple pID (patient Numbers)in a table called [Voucher Table 6 Codes], I have another table called [Voucher Table 6 Codes UDS]. I am trying to count the number of unique pID's in the first table and update the [...UDS] table with the number of pID's in a field called...
  2. burcher

    Age asof June 30, ???? Calculation

    I am trying to calculate a persons age as of June 30, [UDSyr]. The [UDSyr] field is entered on the report form in an unbound text box and is used by several other queries. My age calulation was: UPDATE [UDS Age & Gender Table] SET [UDS Age & Gender Table].Age = DateDiff("yyyy",[DOB],Date())...
  3. burcher

    Form's OrderBy to Report.

    I am trying to send the Form's Orderby and Filter Parameter to a report. I have got the Filter parameter to pass to the report, but I can't figure out how to pass the OrderBy parameter. Here's what I have so far: Private Sub Command47_Click() On Error GoTo Err_Command47_Click Dim...
  4. burcher

    Create an Option Box or Validation?

    I have a continous form that has 3 fields, Begining Date, Ending Date, and a check box for selected. I have a global function (thanks to Bob Scriver) that will read what the beginDate and EndDate are from the TimeTbl and filter different forms. Is there a way to make this form act like an...
  5. burcher

    Setting Global Date(s)

    I have a table called TimeTbl that has 3 fields: BegDate, EndDate, SelectDate. BegDate has the beginning date of the calendar year, EndDate has the Ending Date of the Calendar Year and The SelectDate is a Yes/No Field to specify which calendar year you are working in. I would like to make a...
  6. burcher

    Filter or Global Variable?

    Our company has a program that is funded by the Government, that basically will pay upto $200 towards Health care, $75 towards Dental care, and $75 towards Rx, per year and per Migrant farmworker. The company has a fiscal year from 7/01 to 6/30, which each 7/01 each migrant farmworker is then...
  7. burcher

    Problem Updating Count from Table 1 to Table 1

    I have 2 tables involved:[Voucher Data Table] and [UDS Age & Gender Table]. I need to update the total NumOfEnctrs for each person in a given year(i.e. how many times each id has seen the doctor that year). I have created a query that gives me the correct count:(Count Encounters Query)...

Part and Inventory Search

Back
Top