Search results

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

Just the one. Thanks. Yes - just the application date. I will use this to say..."Who should get their credits applied on (this date) ?" Then the report spits out all the master records who have subfields with application dates fitting the query. QueryByForm : What date ? (user enters)...

Files sent! Let me first of all say THANK YOU. I promise I wont take advantage of your help over and over, but this one part is kickin my arse. Ive sent the file (with the data - its neither sensitive or large and will help with understanding the subforms). In case you're reading this before...

This is exactly what I need. However,im not the greatest SQL programmer. I looked at the properties for the command button on the form and found the event proceedure. Unfortunately its not as simple as merely cutting and pasting field/object names into the command lines. Can you offer some...

thank you! Thanks I could use it! Please send to both apothicsouls@yahoo.com and Jnorris@ms-ainc.com. Yahoo wont take anything over 1.5 mgs so depending on the size, I may not get it there. Thanks.

I need a query based on a search form that runs a report. Basically, I have a form that records a person's name and has a subform with entries that records a date and a name on each line. What I need is to run a query that takes its information from a search form Ive made and automatically...