Recent content by rolfrobinson

This may sound like a daft question but which part of the table do i put this in?? default value. validation rule? Thinking about it would i be better doing it in a form? if yes then could you help me with the expression? if my box no is {1} Item No {2} (its the item{2} that I want TO update...

Hi I have tried searching for an answer with no luck. I am writing a table to do a filing cabinet archive. I have a table with 3 fields in one is box no, second is item no and third is a description. I have the first 2 linked as a primary key. The description is just text. I want to be able to...

Hi I have tried this in a normal query and it works. But in a crosstab query I am struggling.

date sort thanks for that!!! it worked. Do you know how I can arrange them on the query so that they are sorted in date order. What is happening is the dates are been sorted like this :- 01/05, 50/04, 51/04, 52/04 The 01 is been put to the front of the crosstab query. any suggestions...

Week/year number query Hi I have noticed that when you use week nos when the year ends the weeks go back to the beginning again throwing the results out. This is the formula that i have put in my query Week No: DatePart("ww",[Date Sent]) Is there anyway that you could put ww/yyyy? I have...

I have to design something that will cover our late night rota. Our working week is mon -fri with bank holidays. How would I get a query to output in a cross tab table which person covers the late night, and is updated if people leave or we get new starters and incorporates bank holidays...

I have a table which has a dynamic link to an AutoCad drawing. The problem I have is when I want to print out all the drawings via a report. All the 300 drawings open up in a new AutoCad application and slows down the whole process. I have to shut down all 300 AutoCad apps and I cant leave...

Thanks for the website it made for some interesting reading. And made things a lot clearer to me!! I have got an example table and sheet to merge using a union query but on the original it just kept saying syntax error. Is this because when i have done the original links they had spaces...

Im not too good with SQL and I cant seem to relate my database to the quotes on Access help. i have tried before to do a union query but it kept giving me errors. Do you know of any websites which would help me to learn SQL for access, so that I might have a better idea of what I should be...

I have 6 excel sheets all of which are the same format ie name, address, Tel etc plus a unique number, job status and an install date. I have linked the six excel sheets into my database. (They are in excel because that is how i recieve them via email from someone using MS Access and they cant...

Hi Everybody I hope this is in the right Forum, I have a database that I am writing at a company which has a huge I.T. Support, yet no one willing to help. I am a beginner and I am using Access 97. I dont understand VB or how to program in SQL although I understand what it is doing I...