Search results for query: *

One problem solved, and thank you for the ideas. I still don't know why it's happening, but when the limited users cannot access the internet, IE7 has a "diagnose connection problem" in the tools menu. This starts up and finds a problem with Winsoc and after a restart we are good again...

I found this and started into it and it asks if you can browse from the host and client computers. We aren't on a network, just different users on one computer. Does the term network ever apply within one computer? All the help seems to be for sharing a connection between computers. We just...

Linney, We tried the login as you described. Nothing changed. Same response. Thank you for your help.

Thank you for your help. The web browser says "page cannot be displayed" and "you might not be connected", but the computer definitely is. We have broadband, a new one today, and it is reacting the same as the one we switched from, which was also broadband. I don't know if they can access...

We are running XP Home and having trouble with the user accounts accessing the internet and some programs. We also have AVG for anti-virus and firewall and Registry Patrol. We selected these two because they did allow the other users to access the internet when we loaded them. Now we can't...

Well, I found a workable solution. The Excel option acutally would only have worked, if I wanted to re-enter my data. I opened the export from Access and tried to reformat the cells to text, and it didn't keep my data, so I went back to Access and changed the cell format to text. The only...

I'm merging from Access to Publisher (ideally) and one field is an appointment time. In Access it is formatted as "medium date" (ie 1:04 PM). When I merge to Publisher it comes out 1:04:00 PM. I found an article addressing this issue, and the recommendation was to use Excel and reformat...

Never mind, I found it in the help files: Zip:Left([ZIPCODE],5)does just what I need it to. Thank you, thank you! Aimee

MichaelRed, Thanks for the quick response. Can I have more specific instructions? Thanks! Aimee

I need a report to show how many people we track/service in each zipcode. I have a simple query that shows City, State, and count of zip, but not the zip codes themselves. In this view, it seems to show just what I need to know, for instance, Greensburg PA 168 (count), except for the zipcode...

I'm back. I was sure that it had worked, using the max function, but when I attempted to use the query yesterday, I find that it is listing people whose latest gift was within the date range, but also any other (usually just one) gift given in the date range. I need to merge to a letter that...

Thanks for your help, all! I accomplished it using mostly the design view, but used the max concept (which is new to me). I had to use it with the dates, though, because in my fiscal year system FY99 would be perceived as more "max" than FY00, I would think. Aimee

gol4, Thanks. I think I'm starting to understand. However, I'm not great at trouble shooting these things yet. The query you wrote out for me is returing "syntax error in Group By". I tried a couple things, but didn't get anywhere. I also saw the post about learning SQL and...

Thanks for the suggestions, but I'm not sure just what to do with them. My query(s) pull from two tables. The Master table stores name, address, etc. The Donations table stores every instance of a donation. I don't need all the donations from FY00 and FY01. I just need to know the people...

I am trying to produce a list of those who donated to our orchestra in FY00 or FY01 *but not* in FY02 and FY03. (FY=Fiscal Year ending) The query [FY00 or FY01 but not FY02 Donations Query] produces a list of those that donated in FY00 or FY01 but not FY02. However a few of those did give...

Thank you. With the space (no underscore) and [ ] it worked! Aimee

The spellings are correct. The table is "Donations". But the field is actually "Fiscal Year" in the table. I added the underscore (Fiscal_Year) in the SQL. That was just a guess on my part. Is this relevant? Should I not use spaces in my field names? Aimee

Thank you. It's starting to make sense. I've learned a lot this week! (I just found this site a week ago. What a find.) Aimee

Since reading a previous thread that matched my project ("Basic Query Question", MooseMan, thread 701-281213) and posting a question, I learned a litte more on my own. I now understand how to use SQL View in a select query. I tried the following, to return the members that have...

This thread asks virtually the same question I am trying to solve. The problem for me is that this doesn't look like any *query* I have done. Is this text for a VBA module? If it is, how do I use it as a query for a report? Could someone explain this at a lower level? Thanks! Aimee