Recent content by Hans

Hello. I am trying to make a composite primary key for a table with a field for ID and REGIONID, but am not allowed to save it with these changes. I am given the "changes unsuccessful...duplicate values in the index, primary key, or relationship..." message. I have tried all I can think of...

I'm just trying to figure out the way to have two non-unique IDs for records within a table. For example: In my database an office has an ID, and every office has a Region ID. However, an office from one Region may have an ID the same as an office in another region. 24 5 22 99 24 16 18...

I have a query that uses the parameter between [start date] and [end date], and I need to add a modification that changes the year to the year before. Something like: DateAdd ("yyyy",-1,Between [start date] and [end date]) This returns an error of course but you hopefully get my idea. Anyone...

I'm trying to use this MonthName function and it's not working (surprise). Within a query I'm typing MonthName([What month?],False)where the "[What month?]" is a parameter requiring 1-12. Nothing works. Any ideas?

Thanks, just figured it out the second part. I should have checked Access Help a little closer, as my answer is very clear there. Thanks again.

Thanks! Now how can I keep the standard format #,###,### and still get the + result?

Hi. I am trying to get a calculated field in a report to show a "+" sign before a positive number. Is this possible, like most other things in Access seem like they are?

This date issue was a real sticking point,but now your ideas are helping a ton, and I will soon move past it. Thanks so much!

Does anyone know of a way in a query to have criteria that takes [date] as a parameter, and returns the date but with a year less than what was typed. For example I type in 1/6/02 and it returns 1/6/01. I can have a [date]-365, but that doesn't work. I need the exact date from the previous...

Thanks so much! I hadn't declared the parameter datetime. Not sure why I had to add it this time and not other times when I simply put a [What date?] in criteria and it ran ok?

I'm trying to have a query ask for a week ending date, and give data for the date and 6 days previous. Therefore in criteria of Date column I say "Between [Week ending Sunday] and ([week ending Sunday}-6)". Do you see what I am trying to do? Shouldn't this or something close to it work?

When I try it, I'm getting a "#Error" ??

Hello. I am trying to insert a text box at the bottom of a sales report that calculates the total of one of the columns (in this case, net sales). I can get a running sum, for this, but not just one final total. Is there a way in the report to get the result? Or, should I approach this from...

I was unclear in my question. Basically, I'm needing to get a rank of two fields in a report. Setting up one field for this in the report works fine (use control source =1 --it's basically a rank). The other is more difficult. So, I'm assuming I need the query itself to produce the rank so...

I can get a simple count of the records in my report by setting control source=1 and "over all", but I need to do this within a separate field in the query itself. Any suggestions would be greatly appreciated!