Search results

Sorry the subject isn't great, but I have the following field which calculates the difference (in days) between a field called LastTR (which is a concatnation of three seperate fields and then formatted as date) and today's date. Diff: DateDiff("d",[LastTR],Date()) It returns the value...

OK, I've searched and searched and searched but I can't find the answer to this question. I have a field which is 6 characters long. I need to get the middle two, how do I do that? The source of the original field of 6 characters is out of my control so i can't change that, i need to create a...

I work for an insurance company and we use the julian calendar to track the age of claims. So so for example, a claim will be assigned 03032 if it was received on 1st Feb '03 - this is then used as the 1st 5 digits of the claim# assigned to it. What I need to do is create a query which will...

I'm know this is possible, and in fact I was nearly positive I had posted this question before, but after a search I still can't find the answer. How can I set a report so that the Group By header appears on each page, not just the first one? I've checked in the report properties but there's...

Sorry, that's not a very good descritpion of what I want to do, but it's the best I could come up with!! I have a table called MasterTable upon which all of the queries within my database are based on. Within the MasterTable there are two fields (well there's more ... but I'm only concerned...

I don't know if this is possible, but I hope it is!! I have a table, generated by a make table query. The table is then the source for a report. Basicly, I want to be able to do a custom group by in the report. Each record in the table has a field called group#. I don't want to just group...

I've searched this forum, but I can't seem to find the answer. I have an three macros - one called queries runs a load of queries. another called reports, prints some reports, after the queries have run. I have a third - AutoExec which runs the queries macro, then runs the reports macro. The...

Is it possible to setup a query to search a table for duplicate records and return all the duplicate records? If so, can somebody tell me how? :D

I have some make-table queries which provide the source for some reports. The source for the queries is linked to another database which I have no control over. One field (age) is always displayed with five digits. So if the age was 19 - it would display 00019. This isn't a problem in the...

I have a delete query and an append query which deletes old data from a table and updates it with data from another table. the first field is sorted ascending, and more than one record will have the same value in this field. For example, the first five might say 001, then the next 2 might say...

Is it possible to have bullets in a text box in an access report? If so, how do you do it?

Is it possible to do the following? I want to create a table which would list every date of the year 2002 and a corresponding number of hours, eg for Monday the hours would be 8 but for Saturday the hours would be 0. Then I want users to be able to enter a "from date" and a "to date" in...

Please can somebody help me. I have an access database which uses an AutoExec macro to run when it's opened. I runs some queries and then prints some reports. However, when I open it, the macro starts to run as normal, but then I get a windows error message saying it can't find the file and I...

Is it possible to split a field (eg name) into different elements (eg first name, last name etc)? I'm using an update query to update a table from an externamlly linked database (linked table) and need to split a field into individual elements. Can anybody help?

I have some Make Table Querys which are run every day. Is there a piece of code that I can put in to add an extra column which would have today's date in it every day? Thanks for your help

I currently have an Access2000 database with an AutoExec Macro which prints a number of reports every morning so that they're ready for use when employees arrive for work. However, sometimes these reports have no data on them, depending on what was received the day before. Is it possible to...