Search results

I have the number 2334566 and need to know; How many times each number appears and then sort them accordingly ie... Number = 2334566 Number and occurrences 2-1 3-2 4-1 5-1 6-2 Results 2453366 I am trying to do this in VB.Net and it is driving me nuts. The number 2334566 is a randomly...

I agree with you on the table option but I don't have that luxury. How do I make it a view?

I've been using Access for several years and am now switching to SQL Server 2005. Once I have created a union query How can I query against my union? I would assume that I need to name my Union Query but that does not seem to be working for me as I have done to the previous queries that makeup...

It's not actually brackets that access is putting inthere just the closest thing to being able to putting a box on the post. It is a bullet in the shape of a box/square that Access is autofilling. when the report comes up it loks like this, rememder the [] are actually boxes/squares 1) []2)...

I have a interesting problem. I have noticed that there are users that have been looking for a way to add bullets in Forms and Reports. I have just the opposite. I have a linked table that is bringing in "numbered work instructions" ie 1).........2)...... . Access is automatically putting a...

I am lost with how to use that. Meanwhile I'm trying to make sense of something like this Expr4: IIf(Len([NOTETEXT_I])>0,(Left([NOTETEXT_I],InStr([NOTETEXT_I],"4)")-1)) & " " & (Mid([NOTETEXT_I],InStr([NOTETEXT_I],"3)"))),"") Which of course is just making a mess. If I could just get it to...

It can be. This is somethig we just started and it could go to 1: 2: or evensomething else. But for now yes.

I wish I could. The information is coming through and ODBC, where in the source table the individual users are only allowed to put in one long line. That's where my problem is stemming from

I need to be able to take a list of instructions like this one, that is in a table, and have it break out in a query so that when I go to use it in a report it will look like the second example. 1) Set the oil out so that it is at room temperature. 2) Mix the oil and the alcohol together. 3)...

Have your form pointed to a query. In the Query in the Criteria Line of your column put in a parameter. The Parameter should look something like this. [Enter Name]

This does not seem to be working for me. I am needing to put this into the Field of my Query in Access. When I try using your example I am getting errors

I need to bee able to query out all entries that are not like the following format S01-19-01-3. Users are entering incorrect data such as So1-19-o1-3, S0119-01-3, S01-19-01-3. Users are supposed to enter the data with One letter, 3 dashes and 7 numbers. If they enter any other way I need to...

How do I make this Work. I know it should be easy but I just can't get it. If text159 is blank and the Stage field is equal to 4 then make blank otherwise show the Quantity. =IIF([Text159]="", and [Stage]=4,"",[Quantity]) So if both are True then Blank but if [Text159] is false and [Stage]...

I tried that and since there is another column that has to be there I end up with the same result. So it did not work.

I have been trying to get this all night. This was my last attempt. I know it is all wrong and messed up but after 10 hrs I go for help. There is no date field to work with. Expr2: DSum("[Amount]","[List]","[Item]=" & [Item] & "and [FinItem]>0")+0 But it ended up like this. Item...