Search results

I have a large database filled with customer records. Some customers come one time. Other customers come 50 times at year. I want to find all customers that have records that are less than 30 days apart so I can ultimately see the types of products they buy. How do I write the query? I...

Is there any way to make the results of a pivot behave more like a spreadsheet? See attachment. I want to see every row display every data element, unlike the pivot's merged grouping of a category.

What is the formula I need to use to return a text header that is in the same column of the cell which has the max value within each row of my spreadsheet? My spreadsheet has 1,000 plus rows and over 60 columns so I need a formula. See the attachment below for the example. Thanks in advance.

Is it possible to create an SQL expression that joins the two tables together based on the right five characters in one table and the full field in the other table? I realize I could accomplish this by adding a query to the process, but I don't want to create another query. Is it possible...

Is it possible to create a function in access that can "see" how many current users are in a particular database? In a perfect world I could narrow it down to a PC address/user, but I can live with function that can tell if there is someone else in the db. If so, can you give me a hand? And I...

When I change the name of a table, why do some of my db's automatically update the table name in queries and some don't update. Is there a trigger mechanism for a query to automatically update the table name? Thanks in advance!

I set up a switchboard that opens up a few data entry forms. It sits on our network and around ten users assess it throughout week. There is one user that can't open up the switchboard anymore (he used to be able). Now he as an error that opens up the visual basic debugger. The error it...

I can't quite get the second part of my expression to work..... I am trying to take a date field, ex. 1/1/44, and update the column with a CCYYMMDD format. Here's what I got so far: CCYYMMDD: Right([Dob],4) & Left$([dob],InStr(1,[dob],"/")-1) & Mid$([dob],HELP with MID....... Thanks in...

Can someone write an expression for me that removes preceeding 0's from a column? The column has a mix of Numbers and Text so changing the field type isn't an option! For instance..... Transform this: 0045676 068 00356796 045678 V45678 Into this: 45676 68 356796 45678 V45678 Thanks in...

Is there a way to change the default table size when adding a new table in design view? I am tired of resizing every table I add so I can see all of the field names. Thanks, TheRAT

I have two columns of data: Person ID and a charge code. A person can have a number of different charge codes (different procedures). I want to create a table with one person ID per record and their associated charge codes. I don't want a cross-tab because there are too many charge codes and...

I am a self taught VB newbie. I found code for a single line to be dynamically drawn from the Microsoft Website. Can someone help me with the code for multiple lines. I need a line on the far left of the report, in the middle, and on the end. Thanks! //Single line code// Private Sub...

I am trying to create an access report that looks like the attached word document. The difficulty I am having is trying to get all the data on one page. The projects that I and my teammates worked on last week don't necessarily link to the projects we will work on next week. The data sits in...

I have a large table that I want to add a database column to that calculates market share. In this new column I want to divide [people served]/ by the total number of [people served] for a particular [region] and [service line]. I tried the following expression in my attached sample database...

Question: I work in healthcare and a vender wants me to send ICD9 codes without a decimal. Is there a function in access to drop a decimal, ex.98.98, and result in 9898? Thanks in advance!

I posting this question last week and no one responded! I can use this function (conditional formatting) correctly in the details section of my report, however it doesn't seem to work correctly with the footers. My footer sums my data from the detail level and also takes the percent change...

I have just upgraded to Access 2000 and have been playing with the conditional formating function. I like it a lot. I can use this function correctly in the details section of my report, however it doesn't seem to work correctly with the footers. My footer is basically summing my detail and...

I have a huge report that calculates the percent change over the previous quarters in the detail and footer sections of my report. My VP wants to scan the 20+ page report and easily find significant changes. Question: Is there a way to highlight the changes that are >5% or <5% with a...

There is probably a simple answer to this question. I can't get a particular statement to work in the header that works in the footer. =[MSA] &" Region" When I preview this statement from the header in reports I see "#Error." Yet this same statement works in the footer. Any thoughts...

I am sure there is a quick fix for this. I am building a report that uses a query. The query performs simple calcuations like percent change. There are a few rows in this query that are dividing by 0, so the result is "#error". What is a simple expression I can write in the report design...