Recent content by y2k

Good Idea, didn't think of combining the fields. Howeve, I'm back to the same problem. It's asking for the parameter of LastTR. This is driving me nuts, what's wrong with it?

Thanks, that seems like a good idea. however, the same thing is happening now with that field. It's stopped asking for the LastTR parameter but now, it's looking for the Diff parameter. I created a field called IncludeFlag and stated that IIf([diff]>3,"Y","N") but then when I execute it, I'm...

No, that was a typo in my last post, sorry!! I even tried chaning the name altogether in case I had put in some character and just wasn't spotting it but to no avail, it's not working. Is it because LastTR is also a calculated field?

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...

julian day counts the number of the day in the year, so 001 would be January 1st, 032 would be February 1st because it's the 32nd day of the year. We just append 03 to the start of that so that we can also record the year.

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...

solution OK, I found out the answer to this so I thougth that I should post it incase anybody comes across it for future reference. simply go into the properties of the group header and set the Repeat Section property to yes

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...

Pat, Actually, after I posted this question I thought of exactly the same thing myself!! (of course it's easy to claim the credit now, isn't it!!) Some groups numbers won't fall under any heading. They still get grouped together, but I want to put a heading on the report for each group of...

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

Great Posts... thank you both. That's solved my problem