Recent content by waynewe

thankyou, however created a temp table to store the records required as follow. this seems to work fine. sSql = "SELECT DISTINCT InvoiceItem.dbinvoiceno, Invoice.dbdispinvoiceNo, Invoice.dbinvdate, Invoice.dbpayername, [dbgivenname]+' '+[dbsurname] AS dbpatient, Invoice.dbdob, Invoice.dbtotal...

yeah tried "BETWEEN A AND B OR C AND D" like everything else however doesn't return correct records if at all

because there actually stored as text due to that no only items can be numeric but alpha numeric ie. 110 74123 0MYT99 etc.

agree with you, however if you adumping data to a control set that sort property where possible

yeah thanks i didn't want to but decide temp table way to go.

it doesn't return anything i know there are records in the db that meet the criteria here is a simplified version SELECT Invoice.dbInvoiceNum, Invoice.dbInvoiceDate, Invoice.dbFamilyName+' '+Invoice.dbFirstName AS dbPatient, Invoice.dbDob, Invoice.dbPayer FROM InvoiceItem INNER JOIN Invoice...

you could do either ([tblJobDetails].[timeIn] Between #" & Format(cboDate, "mm/dd/yyyy) & "# AND #" & Format(cboDate2, "mm/dd/yyyy) & "#)" or alternatively ([tblJobDetails].[timeIn] >= #" & Format(cboDate, "mm/dd/yyyy") & "# AND [tblJobDetails].[timeIn] <= #" & Format(cboDate2, "mm/dd/yyyy")...

It doesn't save the page settings just the query structure, however if you resized columns etc. you'll find that would be saved. I find it crazy so I normally would Print Preview prior to printing to modify to ensure I get what I want.

your mising the point. I don't want just dbItemCode Between '1' AND '5267' OR dbItemCode Between '57506' AND '58115' If it's Between '1' AND '5267' then want to ensure, and select records that also contain items Between '57506' AND '58115' I am not interested in just either range, want all...

What you need to do is get the existing student then add and data to the project table and ensure the foriegn key is the StudentId or StudentNum. I am not sure of your ability however if you managed the first tasks can't see why this is a problem. Just attached sub-forms (data-entry) off the...

try the following, sure it's what you want? http://www.tek-tips.com/viewthread.cfm?qid=1247099&page=1 and http://forums.devshed.com/postgresql-help-21/possible-to-use-inner-join-with-delete-84540.html http://forums.databasejournal.com/archive/index.php/t-29848.html...

Hi gurus I'm looking for query to extract records from one table linked to another table based on different ranges. Now here goes. SELECT Invoice.dbInvoiceNum, Invoice.dbInvoiceDate, Invoice.dbFirstName+' '+Invoice.dbFamilyName) AS dbPatient, Invoice.dbdob, Invoice.dbServiceProvider...