Search results

Code: SELECT DMin("[DischDate]","Customer30DayFlag","[CustomerID]='" & [CustomerID] & "' AND DischDate>" & [DischDate]) AS NextVisitDate, * FROM Customer30DayFlag;

Re: Almost there... IDEAL Layout Included... This didn't work yet. I've attached a picture of the sample result of the NextVisitDate criteria you provided and also a picture of my ideal layout. Can I get your help with the criteria for both LastVisitDate and NextVisitDate? Once I have these...

I am not a heavy SQL user and need a little more hand holding. Can you show a picture of the approach? Or, be as simple as possible... I tried Dmax/min but am not sure if/how to use it to compare to each customer's closest prior and post record. If I could figure that out, then I could do...

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.

It worked! Shades, Thanks for fast and accurate response!

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.

Her answer was that it needed to be resized (more) ....which isn't the answer we wanted to hear.

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

Still need a little help... I created a generic form with a button. In the button for the "on-click" event, I have an event procedure with your code. As I press the button, the input box appears asking for the location. So far so good. However, when I type in the location of the db, the...

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!

Ok almost working now, but what about nulls.... I added the reference to microsoft excel and got it to work on my small test file. I ran into a run-time erro '94' invalid use of null when I tried to run the update query on my table (~200,000) across several columns. Some columns don't have a...

Looks good, but I have a problem... I saved a module with the new function and wrote a test query that called the function, but there was a run time error '424'. The VB code line "removecharacter = ..." is highlighted. Do I need to have a certain reference library checked for an excel...

Not sure how it is relevant to the question, but ... I am part of a planning department for a large healthcare organization.

Challenge: I am still having problems.... I couldn't get the previous poster's expression to work. Here's my revised expression. =Mid([txt],1,instr([txt],".")-1)+Mid([txt],instr([txt],".")+1,len([txt])-instr([txt],".")) This expression works with codes that have a decimal, but it drop codes...

And the answer is..... Not a missing reference! But thanks for playing. :) This behavior was a result of a damaged or a corrupted Microsoft Data Access Components (MDAC) stack. http://support.microsoft.com/default.aspx?scid=kb;en-us;306132&Product=acc

Missing reference I searched the site and found what I thought was the answer, but..... I looked in the VB debugger in tools>>references and I looked for "missing" references. I didn't see any. Will it be obvious if there are missing refs? I compared the computer that works correctly with...

Still don't understand.. Missing reference, from where?..... why is he the only user that experiences this error? Help me understand... Thanks

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