Search results

Rob, No that didn't do it, it returned the same data. The query is returning data in grouped duplicates as follows. example 1 FirstName John John John LastName Smith Smith Smith SSN...

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...

Can anyone offer help or direction on this. Thanks

Add a text box to the report header and set the record source as. =" Week Of: " & [Enter Start Date] & " Thru " & [Enter End Date] With "Week Of" being any text u want ie: Date Range etc. Data in parenthesis must be same as in query

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...

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...

Pat, Thank you very much. I didn't even think to look for the query wizard. I've tackled lots tougher access problems than this on my own before--I don't know where the mental block came from on this one though. I can't spend as much time as i would like learning access. It's difficult without...

Is this post slipping past everyone, has it been addressed in another post. Could someone respond, perhaps my question is so dumb that its being ignored. Please anyone.

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...

Viola I got it to work!!! I put text box in details section of report named it RecordCount and put record source =1 and visible as no. Then put textbox in footer and record source =RecordCount. Thanks

I have checked the archive for distinct count and it seems to me that no one has given a clear answer on returning a distinct or unique count. With some of the other problems I got help with on this forum I'm sure someone can explain this in laymens terms. Thanks again for assisting us less...

Thanks Sohaila, But I still can't do what I need. I'm not good with VB code at all. Report is pulled up by date range (A given week) so JAMES may have 5 records that are summed on the report which only shows the summary (no datails) When I put a textbox in the header or footer with Count(*) in...

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...

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...

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...

I'm still hoping for some additional help with this problem, hopefully someone can explain to me how to make this work. As always thanks

Rich, Are you saying to add the date field again in the query or the table, because I have removed and re-added the date field a number of times in the query to no avail. Can you clarify your second suggestion " define the parameters StartDate Date/Time" where/how to do this. Again thanks

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...

David, Again Thanks, It works perfect,it's easy when you know how. I'll make sure to limit one question per post. Any suggestions for a good VB book for beginners.

David, Thank you for the reply. When I put the code Me.TravelCost = Me.Mileage*0.31 I get an error "macro or macro grooup doesn't exist or macro is new but hasn't been saved. When you enter the macrogroupname.macroname syntax in an argument,yoou must specify the name the macro group was last...