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 TouchToneTommy 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: officeguru
  • Content: Threads
  • Order by date
  1. officeguru

    Using Excel 2003 to Manipulate Access97 table

    Greetings! I maintain an Access 97 database for a small group of users. When our company upgraded from office97 to office 2003, they didn't get Access 2003, and they removed access97 from most users desktops. Is there a way to use Excel 2003 as a data-entry tool for Access 97? I know I could...
  2. officeguru

    Disappearing relationship

    Hello, I am trying to create a report with the report wizard based on two related tables. Access (97) tells me I am trying to include records from two unrelated tables. [COLOR=green] You have chosen fields from these tables: Service Parts, BOM Rejections; one or more of the tables isn't...
  3. officeguru

    Counting parent but not child records in query

    Greetings, I have two tables that track publications submitted for proofing. Table 1[BOM Review] holds the name of the writer[Leader], the ID of the publication [Pub #], the date it passes review and a checkbox [Status] indicating it has passed. Table 2[Rejections] is related on publication...
  4. officeguru

    Counting and comparing to total in query

    I hope I am not offending your intellect but I can't figure this one out. I am keeping track of writers/publications in Access 97 each publication has a due date, a completed date, an intermediate date and a yes/no variable. I am trying to create a query that will count publications that are...

Part and Inventory Search

Back
Top