Search results

Hi all, i hope someone can hlep with the following: I have a table like: Date 01/01/2005 10/06/2007 12/12/2004 01/03/2006 02/03/3006 I would like to create a query which calculates the difference between the date in each row and the date in the previous row. So the difference between date in...

Hi All, I hope someone can help me with this odd little problem! I have a query with 2 fields, one called 'list size', which contains 4 digit numbers, and another calculated field called 'list size per 100', which has the simple formula '[list size]\1000'. The problem is this field rounds the...

Hi, I wonder if someone can help me with the following problem: I have a table with 2 columns,start time and end time, both containing time values in a four digit format, eg 0930 being 9:30am etc. I have made a query to convert these into the standard format (eg 0930 becomes 09:30), using...

Hi, I wonder if someone can help me with the following problem: I have a table with 2 columns,start time and end time, both containing time values in a four digit format, eg 0930 being 9:30am etc. I have made a query to convert these into the standard format (eg 0930 becomes 09:30), using...

Hi all, I am a VBA in Excel/Access user, to a pretty high standard and am wondering how much of a jump learning other VB languages would be such as .NET or VB itself. Could anyone advise? Thanks in advance.

Hi, I hope someone can help me out with this problem: I have 2 tables with identical stucture, and no unique ID number. Both had identical data, and the databse was then copied onto 2 laptops. Now further data was added onto each. I want to now merge the three databses (ie original one, and 2...

Hi, I am hoping someone can help with this problem. I have a table which has an autonumber field, set to increment by 1. I would like this to start not from 0 but from, say 1000. Is this possible? Thanks in advance!

Hi, I have the following problem which I hope someone can help me with: I have a form which is used to enter data into a table. One of the fields is 'Code'. I want the form to check when data is enetered into this field is it already exists, ie if the code is already present in the 'code' field...

Hi, I have a form which is linked to a table. The table contains the field 'Code'. The form is used for entering data into the table. I would like to write some code so that when the 'Code' field is filled in, it checks if this code already exists in the table, and if it does a message comes up...

Hi, I have the following problem which I hope someone can help me with: I am importing a CSV file, one of the field in which contains times in the following format: 1200 (ie this is 12:00, th text file does not contain the : separator) I want these to be recognised as time values by access...

Hi, I hope someone can help me with this little problem: I have a query which calculates the number of hours between 2 dates, which are stored in a separate table. The query works fine, and gives me number- the prblem is the table which is created by the query sets the fields to 'TEXT', hence...

I have a table which has a column 'Date', which contains dates in the format dd/mm/yy. I wish to produce a quiery which will produce an extra column entitled 'month', which will match each date to the month of that date. I know there is a formula which does this (called 'month' i think), but i...

My quiery is supposed to search through a table of names, and find the latest timesheet entry date for each name, as follows: ID: 1 Name: John Timesheetdate: 1/1/2005 ID is specific to each name. I want the result to be a single row for each ID/name, and to return ONLY the latest...