Recent content by AlfredNor

thanks Thanks..I guess i should have just tried my best hunch, but thanks for the answer. As for what this gives me...roll the highlights Jim! I work for a CLEC in North Carolina. For those of you who dont know what that is, it's a class of companies that sell local phone service (here in...

What syntax do I use to create a variable that = [ServiceDate] + 1 month? Im trying to make a query that says return all records where [field1] (which is a date) is < [field2 + 1mth]. Can I merely say: = [field1] < (dateadd("m",1,[field2]) ? Any ideas? Ive looked in Help but come up with...

hmmm I thought thats what I did. I created a new field in the table called sumfield. Then I went into the query builder and added it to the query as one of the columns. I chose "sum" in the sort section in that column. But when I run the query, it doesnt sum the (total mins) each set of...

How to I show a sum in a query based on two tables? I have a field in the query for a customer's telephone number and a number for the number of minutes they use. There can be several separate entries under the same number and I want to sum them. How should I go about it? Im the query? In a...

its in both Its in both the real and your sample. The exact same records returned multiple times. They even have the pretty box around them separating each batch. Could this be because of some way I have my data set up? let me know.

GREAT! Yes! It works. Wow - im really learning a lot! Great teacher I suppose ;) I guess my final question is why the report brings up multiple copies of the same search results?

laugh I bet I didnt...Im not even sure what a module is. Whats the proceedure?

sigh Ok found them all...now when I run I get another error of "Sub function not defined"..highlighting the ObjectExists (down under the green)

Im not sure how to do that ;)

CRAP!@#$@# I tried just copying the new items over....but im having trouble. I had to make a new command button...which was easy enough..but now when I run the search form I get a compilation error in the SQL "User type not defined." Im guessing this has something to do with the button/click...

I used the wizard Ahh....I had never saved the Query under the box....I had made it with a wizard so it just ran from the table not a query. Once I checked the properties and then hit the "..." on RowSource the SQLQuerybuilder came up and i made the sort ascending and saved it with a new...

Great got it! PERFECT!! You are a certified Genius. Since new info has been entered into the "real" db over the weekend...I can just copy the parts you made in the "sample" one...and they should work correctly since the field names are the same right? Im also going to be a bit daring and try...

strange I went to the underlying table...and re-ordered the files based on a field (the Customer Name field)...but the unbound text box that I am using to scroll through the list of Customer Names...still has "stragglers." Its really bothering me....I mean I know that people can start typing...

Thanks! Super! my email address is apothicsouls@yahoo.com I'll design the heck out of it...and Ill get a lot of use out of your addition!

Microsoft Access isnt alphabetizing when I use the A -Z ascending button. I click in my customer name field, then hit the button. It works...but there are always a few stragglers...that is to say a P between D and E....or a Q between L and M. Actually...it works with the actual records, but...