Search results

DK & WAYNE FOR THE WIN!!! That worked great. Thank you both for the fix. That worked great and I say THANK YOU to both of you for the help tonight.

I have 2 memo fields that I need to combine into one memo field in the table.

raskew thank you for the try but it did not work. it changes it to Memo: Trim([Special Comments]) & [vbCrLf] & Trim([CompNotesInternal]) it then looks for a field called "vbCrLf" anything else?

I am need to combine 2 memo fields from the same table. MEMO: [SpecialComments]+" - "+[CompNotesInternal] Can I take out the " - " and somehow add a return key? If I do the merge right now it shows one continuous string of text. I would rather they have two different lines. Thanks.

I think I can figure out the staple stuff at the end of the job. I just do not know how to set up a report to show the first page with records, then the extra pages, next record & extra pages, next record & extra pages, next record & extra pages, ... ect. for the 300+ clients.

I am not good with reports but here is what I want. My table has 3000+ clients. A couple times a year we have to mail them out a packet. Each packet has 5 pages, one page from the database with their information and then 4 extra pages we print from Word. We then take each page from the...

please do not worry about. I figured it out... thank you all.

I have a query with the "Switch' function that looks like this PASS: Switch([Date1]<#1/1/2007# Or [Date2]<#1/1/2007#,'FAIL') Works great. I now want to add the OR IS NULL into the mix and I am not sure how to do it correct. So I want it to say logically If Date1 is before 1/1/07 or is null...

I deleted some data out of a field so it should be empty. However when I filter for "Is Not Null" by that column those records still show up. Is there a footprint of stamp the database adds that I cannot see?

I need to generate a random list of records. I have a table with a couple thousand records. I want to build a query that when I click on it, it will ask "What percentage of records do you want to see" if I type "50" the query will randomly return 50% of my records. Randomly being the key word...

I have a few access 2000 DBs that need to be switched over to SQL 2005. I want to host the tables on my SQL server and keep all queries, forms, reports, ect in access. I have my SQL 2005 server up and running, I have the Access DBs on a file server. What is the best way to get the tables...

Old code PASS: Switch([AD_DrugDate]<Date()-365 Or [AD_AlcoholDate]<Date()-365,'FAIL') This used to look at everything from the past 365 days. I need to change it to show all of the current year, and all of the last year. So if I ran it today it would show all of 2008 and 2007 records for those...

SP3 here. think that is it?

I just looked at every character & it is EXACTLY as yours however I still get the "Data type mismatch in criteria expression" error SELECT Max(DateValue([DateBilled])) AS MaxDateBilled FROM tbl_TESTS HAVING (((Max(DateValue([DateBilled]))) Is Not Null)) ORDER BY Max(DateValue([DateBilled]))...

Also I personally appreciate that you took the time to set up a demo database with the same naming structure to test the system.

Yes it is. The Data Type is Date/Time with a Format "General Date"

It gave me "Data type mismatch in criteria expression" Here is my exact SQL code without the formatting. SELECT Max(tbl_TESTS.DateBilled) AS MaxDateBilled FROM tbl_TESTS HAVING (((Max(tbl_TESTS.DateBilled)) Is Not Null)) ORDER BY Max(tbl_TESTS.DateBilled) DESC; Here is my code with the...

I need help dropping a time stamp. I am designing a select query using totals. MaxDateBilled: DateBilled This will show me the most recent record entered into my system. It has a date & time stamp thou. How can I change this to only show me the date? I do not want the time stamp listed or...

Nevermind. I found my error my query was correct. Looking at the incorrect column. Sorry all.

I have 2 date fields and want a query to list the two dates then one extra column with the total days different. I thought this would show me the difference in days but no luck. Is this possible? DaysinLab:[DateRcvd]-[LabRcvd]