Recent content by JeffGMACI

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

They are in Access. For instance, I have one expression that takes a date field, and modifies it: qryTV TVNumber (PK) TVStart (Date mdd-mmm-yy) Expr3Wks (DateAdd TVStart +21d) It won't export or link from Excel since my query has the Expression in it.

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

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

That's not a bad idea. I had also thought of doing a vLookup from a master list. I'll see what works, thanks!

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

Some have TV only, some have radio only, and some have both...

Dodge, When I do this, it limits my query to only the Agent numbers in the master table that have TV data AND radio data, not one or the other. Is there a way around this? Jeff

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

thanks, i got it resolved

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

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