Search results

Thanks again Bob - works great. Thanks for your response also Boyd - but that coding is alittle too high tech for my level (wouldn't even know where to put it !) Regards to both of you

Thanks for the quick reponse Bob - works great. One more thing if it is not too much to ask: I want add a field in the query the creates a date 12 months ahead of the origional date field (the date field is renewal date for membership club, so I would like to auto generate a date that the...

Hi, I have been trying to export a query as a text file including a date field. When it exports the data, the datye field shows the correct dates as enterend on the form of my db, but includes 00:00:00, which I assume is a time. Is there a way to omit this time being appended to the date ? Thanks

Works great, much appriciated. Adrian

Hi, I have a list of people in 18 countries and I want to run a query to list people from countries other than Slovenia and Croatia I have been able to get the querry to work with 'not Slovenia' but cannot get it to omit slovenia and croatia 'Not Slovenia or Croatia' does not work Can...

I found this DateDiff("yyyy", [DateofBirth], Now())+ Int( Format(now(), "mmdd") < Format( [DateofBirth], "mmdd") ) seems to work great. thanks

Got one - thanks, thought it was just me who struggles

Hi, Is there an easy way that I can run a query to find the age of a person based on their DOB ? (ie = 31/3/58 would show as 51) Thanks Adrian

I have set the field called 'ID' to be an Autonumber and set it as the primary key. I fugured that the result in the 'unique number' field generated (with the primary key as the first digit) will always be unique as the Primary Key is autonumber(ing). My goal is to be able to assign a Unique...

I have the autonumber as the key which goes 1,2,3 but I want to give a student a unique personal number with the intial of their first and last name and the year they where registered. The easiest way I could think of (being somewhat of a novice) was to create a field in a query which...

Thankyou for that. Regards Adrian

Hi, I am trying to generate a new field with a unique number. I have used the number from the ID field (this is an autonumer and key) and the initials of the first and last name field and I would like to add the year at the end. I can get it to work with the whole date but have got stuck now...

Brilliant ! - works great. Changed the field to gradetype as advised. Thankyou for that.

Hi. I have a form with 2 fields - one called 'Grade' and the other called 'Type'. Each field has pre-determined entries (20 of them) as in the example below. Grade: Type: 1 = full 2 = Partial 3 = Semi 4 = Westward etc etc.. Is...

Thanks to you both for the for the link and exlination - makes more sense now.

Hi, I have been given a DB which has 2 parts, the first file mydatabase.mdb which I open and another just called data.db The databases I have produced myself as I have been learning (in Access 2003) only have one file and no data file Can anyone tell me the difference, and benifits of 2 parts...

Done that - excellent Thanks for the help DCrake

Hi, I would like to add a yes/no box to a table, and when I try to I get the message that I cannot because it is a linked table. Is there a way that i can unlink it temporarily to add the property and then re-link it? Thanks Adrian

Hi Mike, I have been running the query via a button and then quitting. I never thought of autoexec'ing it at startup - that makes it easier to do. Thanks for that Adrian

Hi, I have a update query (to clear any selected tags) which I would like to have automatically run when I exit the database. Is there a way to do this. At the moment I manually run the query from a form button before I close the db, but sometimes forget to do it. Regards Adrian