Search results

I'm new in Databases and Access, so my problem is very simple. I have a table with three fields: Name (Prim. Key), Start Date (Prim. Key) and Cost. I want to obtain a query with this fields: Name Start Date End Date (where the End Date would be one day before the next start date) Cost Thank you

I've made the necessary corrections and now it's working. Problem: In VBA code dates must be delimited with the "#" symbol, but regardless the computer regional settings, Access expects these literal dates to be in the American format, e.g. #12/31/1999# (mm/dd/yyyy). My dates has the format...

I'm dealling with a problem on positioning a form record by seeking a date primary field. I have simple table with two data fields: 1st field- date as short-date (table primary field) 2nd field - description as text Every time i use the method me.recordsetclone.findfirst to match a record by...

I'm dealling with a problem on positioning a form record by seeking a date primary field. I have simple table with two data fields: 1st field- date as short-date (table primary field) 2nd field - description as text Every time i use the method me.recordsetclone.findfirst to match a record by...