access 2010

I am having a bit of trouble with getting some MS Access SQL to work. Here is the high level: I have values in one table, by15official that I need to use to update related records in another table, investmentInfo. Pretty straight forward except there are quite a few joins I need to perform to...

I'm using a form to run a query. I have a start date and an end date on the form and I want to only return records in the query that fall between those dates. If the dates are left blank, I want the query to return every record. The fields use the Short Date format. I would prefer to do this as...

Hi I have a table of data with duplicate entries for actions that have happened to the same unique ID (Initial_UBRN). I have got a query that will find just the rows where the latest action - [ACTION Date] field - happened but this gives me duplicates as there may have been more than one...

Hello everyone, thanks for taking the time to read my question! Scenario (access 2010): Two tables, tblPersonnel and tblFitness. tblPersonnel contains basic personnel information. The fields of concern are: PID (unique personnel ID, primary key) Last Name First Name Rank Squadron tblFitness...

Hi, I am trying to get a bit of code to work but am not successful doing so. I get a runtime error 3141 telling me my select statement contains a reserved word, misspelled word, punctuation missing or incorrect. Below is the code but I cannot find what is wrong with it. Any help would be really...

Hi, I have a form that my user wants to sort by ascending and descding order. They would like to click on the field title in the header of the form and switch from descending to ascending and back again. Is that a way to do this with VBA? I am very new to VBA and do not have a good grasp on it...

Hello! I am somewhat new to the more advanced features of Access. I am currently using Access 2010 and I am running in to some issues with something I thought would be simple. Here is the story: We are creating a new Personnel table (from scratch) in Access. I'll refer to this table as "Access...

Good Morning! I am trying to keep the number of forms I have down in my database. I have three tables that are exactly the same except for where the product is from. I am not using all of the fields for this printable form, just the ones that the user needs printed out. I plan on having three...

I have broken down a lot of data into three tables that I need to count by month. It took a lot of filtering in other queries to get these three tables. Each table represents a type of part, Inhouse, Outsource and New. How can I combine all of these tables into a chart that gives me the count of...

Good Morning! I have a question about creating a table from two different tables without adding duplicate information. I have two tables that will contain some of the same information but not all. There will only be a few duplicates but I want to be sure that they are not in the new table. How...

Hi all. I have an Access report where each field is in Calibri. However, almost seemingly on a whim, Access keeps changing fields to Century Gothic without my asking it to. If I change them back to Calibri, the minute I save, close and reload the form they're back in Century Gothic again...

Good morning, I have three tables I need to bring together to make one. I am having problems joining two of the tables to get the results I need. The only way around my problem that I see is to create a seperate table from these and join it to my first table. I have a table that contains...

Ok, I've been trying to figure this out for a few days and it just isn't working no matter what permutations I put it through. What I'm trying to do is open a report based on the record in the form (and only that one so that I can save it to a PDF individually instead of in one big congolmerate...

How can I print out multiple reports to a predetermined location without it prompting me each time? I have a macro that prints out several reports but I am prompted each time to select where I want the report to go. Can I predetermine where the reports are sent? I tried output file but that did...

Ok so I've been searching around and I haven't been able to find anything. The end user changed requirements on me (again, yay! *sobs*). Here's the setup: I have a field labeled PLANT in the CLAIMS table. In a form the first field selected for a new record is PLANT. They want a counter that...

I am having an issue with my charts returning higher results than the query I am running them from. I have a query that counts the top ten items used in the last year. I am trying to create a subform or subreport for each chart I need so I can add it to a larger form or report. The problem is...

Ok, so I've spent the majority of this morning, and a good portion of last Friday looking through forum posts related to calculated fields. Here is where I'm having a problem: I have a claims database. My three main tables are: Claims, Payments, and Corrections. On Claims I have a field called...

Hi, I have an issue I am trying to resolve with an Access chart. I have a query that counts how many times a part appears I use as top ten list. I have a chart attached to this query but the chart does not go in descending order like my data does. The chart goes in alphabetical order instead of...

Hi, I am new to Access and need to build a chart that change with a user input. I have a combo box of Plants: Plant 1, Plant 2, Plant 3 and have a chart with a total amount of usage from those plants. I need the user to have the ability of selecting a Plant and the chart change to show that...

H, Is there a way to make a null value become a zero by default?