Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Problems with query

Comment:

Am retrieving a list of appointments (diary) and have a start time, duration and location, together with other fields. Where the location is the same and the times follow on, I'd like just the one record back, showing the complete length of time. No idea where to start ... so far it looks like this ... select A."Time", A."Duration", A."Date", A."Name", A."Number", A."Type", A."Location" FROM "APPOINTS" A WHERE (A."Date" BETWEEN '2009-07-20' AND '2009-07-22') Any help appreciated. Thanks Tony

MS-Access query/report

Validation rule for acces...

Summary: I have a perplexing problem with a Access/Word merge. The Word main document is connected to an Access query. Once the connection was established, the Word document was saved to preserve the DDE lin...

Summary: Hi, I have the following UNION query in MS Access: SELECT DISTINCT "DOM " & mDOMExceptions.ExceptionID as ExceptionID, mDOMExceptions.[Status], mDOMExceptions.[Date Created], mDOMExceptions.LastUpdate...

Summary: Dear all, I have a problem with sql function: I want to change Amount column to Words, senirio is like this: i have a 2 column, 1 has name and 2 has amount in numbers and i want to convert that amoun...