Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Aimee88
  • Content: Threads
  • Order by date
  1. Aimee88

    User accounts internet & program 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...
  2. Aimee88

    Time Format in Mail Merge Access to Publisher

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

    Zip Codes with and without the 4-digit extension

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

    Excluding records in a query using multiple tables

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

    Unwanted "Enter Parameter" box in SQL Query Text

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

Part and Inventory Search

Back
Top