chi2jjk
Last Activity: Nov 10 '11, 08:51 PM
Joined: Sep 20 '07
Location:
-
Pat, your query worked a treat! I did not need to try additional offers - although I am very grateful to each of you, and I have learned from this experience. -
Thank you both. Unfortunately, I will have to have a go with these ideas in the morning as my shift is over for today. Cheers! And thank you emmensly for all of your help today!Leave a comment:
-
Pat, thank you. It seems not to work prompting me for the 'tblB.from_date '. Does tblB need to be referenced in a FROM clause somehwere?
Original code which seems to have produced a cartesian table with almost 2 million records is here:
Code:SELECT tblA.CheckDate FROM tblA LEFT JOIN tblB ON ( tblA.CheckDate <= tblB.ToDate) AND (tblA.CheckDate >= tblB.FromDate);
Leave a comment:
-
MS Access A Different Between Dates Problem
First, Thank you.
I have a table (A) with close to 1000 distinct dates. I have another table (B) with hundreds of thousands of records, each of which contains a "From Date" and "To Date". I need to find all of the records (Dates) in table A that are not encapsulated between any of the From-To dates in table B. In layman's terms, which dates in table A were missed in table B. Table B may have From-To overlaps, or gaps.... -
VBScript problem processing txt file with a function.
Hello experts (bow),
In the code snippet below, I am getting an "Expected End Of Statement" error that is pointing to the middle of the name of the function. Specifically the "c" in fnMaxiclean. Any help is greatly appreciated. I have triple-checked that there are no spelling errors.
...Code:'' Open the file Set objFile = objFSO.OpenTextFile(strFileName, ForReading) '' Clean the
-
Thanks JConsulting! I am trying to use the code above as well (allbeit I am trying to create temporary links to delimited text files) so I have modified a little as below:
...Code:Private Sub Command0_Click() Dim strFilter As String Dim strInputFileName As String strFilter = ahtAddFilterItem(strFilter, "[B]Text Files (*.txt)[/B]") strInputFileName = ahtCommonFileOpenSave( _ Filter:=strFilter,
Leave a comment:
No activity results to display
Leave a comment: