Search results for query: *

I have a table that has multiple records with same patient id but different collection dates. I want to query for the latest collection date? Pt ID Accn # Coll Date 1001 112 6/5/02 1001 113 7/1//02

I have a database linked to a table. I am trying to append this data to a table in my databse. I am getting this error unable to append 36 records to table due to key violations I know there are duplicate records in the linked table and am sure that is the cause of my error. I want the...

I have a table containing "collection date" this is a text format. I want to create a query that calculates the collection date plus 1 year, 2 year and 5 year. This is what I have but get results "Error" in data. [collection date]+365 I tried a DateValue but still get Error

I have a database using several different data sources, of course all three have different date formats. the date formats will not change when I change properties on the report to medium date. Can I change the data by formating the query behind the report? Help please

I have a query that returns data based on fields country in range the country field contains multiple countries, I want to make a report that counts the number of times the country appears the in range field contains OK, out of range, not received I also want to count the number of...

Can you tell me how to delete data from this string. I imported this data and want to delete everything to the right and including the "-" in my query? K457243-3 NOW I need to extract K457243 only

I have two workbooks one for Geneva and one for US. This is data such as Date, Sponsor Name, Trainer Name,... They both contain 6 columns of data that I want to combine into a new workbook or worksheet. I have tried the merge function but can't get it to work. Any suggestions would be...

Since I have added this last field to my querie, the previous fields will not show up on the report. When I remove this total field they show up fine. Please help Thanks - You are awesome!!

I have a querie returning wanted results, but when I use report wizard and select needed columns, I am only getting last of three columns selected. Please help. Thanks by the way this is a great website, you guys are really good

It worked!! Thanks

Thanks, I think this is my problem but I still can't get it to work. Here are the two IIf statements I am trying to combine into one total. I have assigned values 1-3 to the below ranges. Now I want to add these values (1-3) together for a total. TA Complexity: IIf(([TotalTA]>0 And...

I am using a text box in a report column, but the properties are set to General Number. Is this not the correct way to insert this into a report? Thanks for your help

I am trying to add to column totals together. Either in the report or query I am getting same result. I have two columns one with a value of (3) and the other a value of (2). When I try to add a column to sum these, I am getting 23 instead of 5. Please advise Thanks