Search results

your explanation does help some. I guess I need to really begin focusing on learning SQL. I've been relying on the built in functions in Access for a while since most of what I do has been simple up to this point. I'm getting into more areas where I want something more complex but I'm still...

THANK YOU!!! It works. Now, can someone point me to an explanation of why it worked? I would have never placed any of that in the field box.

I'm still a little new at this myself but I wanted to toss this idea out to see if it might work for you. I would assume you have a form of some sort to see/enter the employee information easily. Why not design the query to be run on the primary key of the specific record? Each record should...

Thank you all for your feedback so far. Mile-O-Phile, thanks for telling me where it doesn't go. Fizzio, I have never heard of putting anything like this in the Field box. I'll certainly try it today. I've always been told that it goes in the criteria box, but then too, I don't often...

well, it was a criteria :D Is there another way I should be trying to insert this statement into this query? The help file doesn't tell me where I can and can't use certain statements, so I'm winging it. Right now I'm looking real hard at the "Select Case" statement as I think it may be a...

yes, I tried it that way first. I had to add parenthesis because it gave me an invalid syntax error. Even after fixing for the syntax, it still does not pull any records. There are definitely records during that period also. Anybody have any other suggestions?

I'm having trouble getting Access to perform a query involving a date range. Ultimately, I am trying to get it to automatically pick a range of dates based on what the system date is. The query pulls its information from a table called "reports" and the date field is called "RepPer". For test...

You might be right on that template thing. I just DLed it from the office update site. Theirs looks a lot better than mine. don't like the double-click and add to form set up the way they use it. I'd really like to do away with having to type the info only to find it's not there and then...

Rich, a few reasons. One, I think I messed mine up. I have a database called musicnvideo and it has the tables in it, but no forms. I don't recall if I did that or not. Then, it is not in the database template section, so I can't just regenerate another one (unless someone here has it for...

I'm still stuck. Please bear with me, this is my first time doing this and so I hope I'm explaining things the way they need to be. I've looked at all the other notinlist posts on here and seen so many different responses, it's hard to troubleshoot what I've done. I should also state that the...

Using Access 2000, I am making a database for my record collection. I want to enter Album titles, Artist names and several other items. I have everything figured out except for the artist names. I'm using a combo box because I want to be able to choose the name from a drop down list but if...