Search results

  1. C

    exclude records from a find duplicates query

    Hi to all that may see this post, it's been almost 18 months since I last posted here. I have a find duplicates query (created using the wizard) that matches duplicates by LastName and FirstName. SELECT [dup donors no zero zip].LastName, [dup donors no zero zip].FirstName, [dup donors no zero...
  2. C

    find duplicate records in table using soundex

    pairing duplicate records in a table Need help and know no to very little code. Have a table DONORS that has assigned Soundex for finding possible duplicate donors. The fields I need to compare are Soundex,Lname.Fname,DOB,DonorId so that when I create a report from the query I can group...
  3. C

    append query is multiplying records

    Hi all, I am trying to append records to a table "Drive assignments" this table is currently being populated solely by user input via a form. User currently enters all data ie: drivedate, drivesite,drivestartime,driveendtime,driverstartime,drivergotime, driverendtime,etc.. I have set up an...
  4. C

    compare data in query to field in table return difference

    Hello to all... Please if anyone can help with this. Have table "Staff" and table "StaffHrs" which is populated by user entry. Have query "StaffHrs report" to generate report from StaffHrs table. This is what I'm trying to do: When "StaffHrs report" is ran I need for the StaffId#s that are...
  5. C

    Using Count(*)in report with date parameters

    I have a report that sums work hours for each employee in a given date range. I added a text box to count the Name field. Like this =Count(Name). But even though each employees name only appears once on the report, the Count(Name) counts all records for each employee in the date range. How do...
  6. C

    need help creating report from query/total hrs worked for week

    Hi all, I have a query that gets daily hrs worked by employee from a Staff Hours table. The query pulls these fields from table by input date range. Date, EmployeeID, Name, Dept#, WorkHrs, OtherHrs, TotalHrs,. My question is how can I create a report with similar layout as follows. I've...
  7. C

    Selecting both fields displayed in combo box

    Hello everyone. I created a combo box that displays two fields from a query "FirstName" "LastName" I need for both fields to appear in the combo box once choice is selected so that both FirstName and LastName are updated as one field in designated table. I was always told to separate names...
  8. C

    Date parameters and crosstab queries

    I created a crosstab query to be used to generate a report. If I include the date field in the query as is it runs fine, but when I try to use parameters for date, just a simple "Between [start date] And [end date]" without the quotes. The query returns error that jet engine doesn't recognize...
  9. C

    Auto fill calculation in textbox based on entry in another textbox

    I have a two fields(actually textboxes on subform) "Mileage" and TravelCost" When data is entered in "Mileage", "TravelCost" should auto fill. I have tried "=[Mileage]*.31" in the TravelCost Control Source property, this auto fills the textbox but doesn't update data to travelCost field on...
  10. C

    Update text box data to more than one record source

    This is a re-post from original dated 4/13/02, I still need help with this proplem. Is this possible??? I have text boxes on sub forms that hav/e either text boxes or combo boxes on a main form as their record source. Is there a way to get the data entered in these text boxes to update to a...
  11. C

    update text box data to other than record source

    Is this possible??? I have text boxes on sub forms that have either text boxes or combo boxes on a main form as their record source. Is there a way to get the data entered in these text boxes to update to a given table even though another text is the record source, If so could someone explain...
  12. C

    Date Ranges

    I Have a report with a query as record source. Report parameters are by date range set in criteria of query 'Between[Enter start date] And [Enter end date]'. Question, how can I get the date range user enters at parameter prompts to appear on the report. I'm new to Access, Can someone please...
Back
Top Bottom