Search results

I'm using Allen Brown's ConcatRelated function. In my query I get a syntax error for a missing operator. I have tried every possible combination of quotation marks, brackets, single quotes etc imaginable and can not seem to get it to work. I got incorrect results with a couple of my attempts but...

I'm wondering if there are any other ways, besides a crosstab query or pivot table, that I can have one of my fields as a "column header" and still be able to update data? At the moment I'm contemplating a form where users can update their budgeted hours for each employee. In my table I have a...

I have a Db that keeps track of each Departments budgeted hours and relative cost, as well as the actual hours and cost. To calculate variance. I have my tables set up for the actual, this comes in the form of a report through Excel so it's easily imported to a table. It contains Name, week...

I have a datasheet form I'm trying to create, the columns are things like Department, Division, PayRate, CName, etc. That information is all based off of a table. Now what I need are columns off to the right representing the weeks in the fiscal year. So the header would be, for example, Week...

This should be simple but I'm not seeing it for some reason. All I need to do is copy the value of Sheet1.cell and paste it to Sheet2.cell, in some cases I will need to paste the same value into multiple cells on Sheet2 though they are spread throughout. Any examples of how to do this would be...

This should be simple but it's making me crazy. I just want to run a series of DoCmd.TransferSpreadsheet commands to export several queries to one Excel Workbook with seperate sheet names for each query. However my problem is I want this to be a new instance of Excel that the user will then...

The spreadsheet I've attached contains a ton of calculated cells and linked data. The people who created and utilize it aren't necessarily interested in changing the way they use it or populate it each quarter. That being said, my task is to somehow create a way that it can be sent to/seen...

I have a crosstab query, among other things, it counts the field Policy Number to tell me how many policies were sold. Those are a unique value anyway so that count is accurate. I'm also trying to get it to tell me the number of agents that sold those policies. I need it to count the Agent #...

I'm familiar with writing a replace query to replace characters or strings but what I'm trying to do this time is a bit unique to me. I have a string of numbers that will either be 8 or 9 digits in length. The first 1 or 2 digits will be the State code (1-50 hence the discrepancy in number...

I have an Excel workbook with multiple sheets, all the sheets have the same headers and are formatted the same. Problem 1 is I need some sort of loop so that all sheets will be imported, the names will vary so I can't use specific names to import. Problem 2 is that I need to create a new...

I have a form with some tabbed subforms. Master/Child links are set, everything is bound. When I open the form to display records (based on search criteria on the switchboard form), let's say it returns 6 records for someone, they are sorted by date and so the newest would display first. But...

I have a set of queries that need to be exported to an existing Excel file to the appropriate worksheets and within a date range that the user enters on the form. That part all seems to work fine, the correct data goes to the correct sheets, etc. The queries themselves, if opened while the form...

I am using Access and Excel 2007. Here is the general scenario, I know I have used a complicated method, but it seemed much cleaner at the time and I am open to suggestions. This Db is for a mental health practice to track and store the paper questionnaires that the patients fill out. The data...

I have a query that is using my 3 data containing tables. It is selecting the stats that i need from each table using the criteria that the date in the table is last month. they are related by name. (To get last months average of each stat) For whatever reason, not every person has a stat in...

I'm guessing that this is possible, but it's not something I've seen implemented, so let me know if I'm way off base! I have a Db that is used to track Agent Stats. Once a week, Supervisors have a coaching session with each of their agents. Prior to the coaching, the Sup opens a Form, reviews...

I have two joined tables, one to many. The problem I'm having, is the field that they are joined on, is the one I'm trying to count. So access is counting them in the wrong table, basically. Here is the SQL: SELECT DISTINCTROW Contracts.ProductID, Count(Contracts.[Contract No]) AS...

This doesn't seem like it should be complicated, but for some reason I'm not figuring it out. I just want to update a field in a table based what is found in another field in another table. So, I have a Public Function with a Select Case statement. Then I'm trying to call to that function in...

I will try to put this as succinctly as possible, but bear with me! I have a table containing records (duh), and a Form that is used to display those records. More than one record can, and usually does, have the same contract number (separate records for each line in the order). What I'm...

I have a fairly simple Access Form to import new records when reports are run. Reports are run from an Oracle database (no, I can't just connect to it) and put into an Excel worksheet (only output option). So, I just have to import the excel spreadsheet into Access. The code that I'm currently...

I am using a form (I call it a preform) that users select or enter criteria in, the click a button, and another form opens with records that were filtered by a query based on the criteria they entered. The query seems to work just fine. If I just open the query, and type parameters into the...