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 John Tel 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: JeffGMACI
  • Content: Threads
  • Order by date
  1. JeffGMACI

    Making a Table from Crosstab

    Hey guys, I've just made a crosstab query, and was wondering if it was possible to make a table that is based on this crosstab. I can't figure out how to set it to "Make Table" after I change the query property to crosstab. Any hints? Jeff
  2. JeffGMACI

    Exporting To Excel - Problem

    Have any of the rest of you had trouble exporting data from Access queries to Excel? When I try to do this, I get error messages, and I cannot link from Excel to tables that have any of my custom functions included. The functions seem to be causing the trouble - does anyone have any ideas on...
  3. JeffGMACI

    Relating to a field on a subform

    Hello everyone - I have a question and wanted to see if anyone had any ideas for me. I have a table with customer data - customer number, address, etc. Then, I have three tables for different products ordered: tblLocation tblTV CusNumber (PK) AutoNum (PK)...
  4. JeffGMACI

    Merging columns in Excel

    I have an excel question that has been giving me trouble for the last few hours. I have a spreadsheet that looks like this: Jan Feb Mar a103 5 a103 5 a89 2 a104 5 a110 8 a110 1 a111 2 a134 1...
  5. JeffGMACI

    Displaying multiple tables in one query

    I've set up several tables as follows: tblTV AutoNumber (PK) AgentNumber (FK) TVBudget ($) tblRadio AutoNumber (PK) AgentNumber (FK) RadioBudget tblMaster AgentNumber (PK) Agent Name What I'd like to do is make a query that displays all the agent numbers...
  6. JeffGMACI

    Strange Problem with Run Time Error

    I'm having a really strange problem and wonder if anyone can help me. Here's my table structure: tblTV TvAgentNumber (PK long integer) TVStartWeek (short form date) tblNewBus AgentNumber (PK long integer...related to tblTV) 01-Jan-03 (Weeks with long integer data)...
  7. JeffGMACI

    Acces Date Ranges...

    Hello guys and girls. I'm having a devil of a time with something, and thought you all might have some hints to get me moving forward again. I've inherited a database and have been tasked with some analysis but am unsure about how to do the following: I have tables containing monthly data or...

Part and Inventory Search

Back
Top