Search results

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?

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?

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

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?

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

I'm trying to assign a week number to daily records in order to calculate a week to date cumulative. Not sure which direction to take, any suggestions? I had one idea: ((DateDiff(?, Date())/7)??

I have a database that is reporting sales totals for 25 stores on a daily basis. I would like to make a daily sales report that would tally week to date totals for each store, and rank them. The week cumlative for the week are my problem. Where can I establish for example Feb. 7 = Week 6...

We've got a report in Excel getting data from an Access Query. I'd like it to ask for the paramters upon the user opening it (like it would in an Access report). How can this be done?

We are having a tough time keeping entries from being overwritten in our new database. How best to open the form (data entry) to the first unwritten record, eliminating the hassle of clicking to the end each time they open it?