Results 1 to 6 of 6
  1. #1
    gheyman is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    22

    Unhappy Make Table Error message

    I am new to access, so please keep this in mind if you decide to help me.



    I am trying to create a Make table but when I run the Query I get this error message which I dont understand;

    "A calculated column cannot be saved without a valid expression in the Expression property."

    I assume expression equals a formula, but whats the expression property or where is the expression property???

    Thanks

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    What's the marketable command you are using please. (Open your query in design view, right click and choose SQL.) Then paste the SQL on here

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Are you really trying to put a calculated field in a table? If so, why? Calculations really belong in queries.

  4. #4
    gheyman is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    22
    Quote Originally Posted by andy49 View Post
    What's the marketable command you are using please. (Open your query in design view, right click and choose SQL.) Then paste the SQL on here

    SELECT tblCustomerLst.Cust_Corporation, tblCustomerLst.Cust_Division, tblCustomerLst.Cust_Location, tblProgramsLst.Program_Name, tblCommodityLst.Commodity_Type, tblRFPStageLst.RFP_Stage, tblProposalStatusLst.Proposal_Status, tblRFPManager.PID_Number, tblRFPManager.Bid_NoBid, tblRFPManager.Charge_Number, tblRFPManager.Proposal_Title, tblRFPManager.Proposal_Description, tblRFPManager.Prime_Customer, tblRFPManager.RFP_Number, tblRFPStatusLst.RFP_Status, tblSalesTypeLst.Sales_Type, tblCountryLst.Country_Name, tblSolicitationTypeLst.RFPSubmittal_Type, tblBusinessTypeLst.Business_Type, tblBidTypeLst.Bid_Type, tblRFPManager.BP_Budget, tblContractTypeLst.ContractType_Acronym, tblApprovalClassificationLst.Value_Classification, tblJobCatagoryLst.Job_Catagory, tblRFPManager.Win_ProbChart, tblRFPManager.RFP_ReceiptDate, tblRFPManager.RFP_ExtendedRspDate, tblRFPManager.RFP_RspSubmittalDate, tblRFPManager.Submittal_LetterNumber, tblRFPManager.Expiration_Date, tblRFPManager.Proposal_AwardValue, tblRFPManager.Award_Date, tblRFPManager.POP_Start, tblRFPManager.POP_End, tblRFPManager.Project_Number, tblRFPManager.Contract_Number, tblEmployeeLst.UserID INTO MktblRFPMgrGlobalFilter
    FROM tblJobCatagoryLst RIGHT JOIN (tblApprovalClassificationLst RIGHT JOIN (tblContractTypeLst RIGHT JOIN (tblBidTypeLst RIGHT JOIN (tblBusinessTypeLst RIGHT JOIN (tblSolicitationTypeLst RIGHT JOIN (tblCountryLst RIGHT JOIN (tblSalesTypeLst RIGHT JOIN ((tblJobTypeLst RIGHT JOIN (((tblProposalStatusLst RIGHT JOIN (tblRFPStageLst RIGHT JOIN (tblRFPStatusLst RIGHT JOIN (tblCommodityLst RIGHT JOIN (tblProgramsLst RIGHT JOIN (tblCustomerLst RIGHT JOIN tblRFPManager ON tblCustomerLst.Customer_ID = tblRFPManager.Customer) ON tblProgramsLst.Program_ID = tblRFPManager.Program_NameX) ON tblCommodityLst.Commodity_ID = tblRFPManager.Commodity_TypeX) ON tblRFPStatusLst.RFPStatus_ID = tblRFPManager.RFP_StatusX) ON tblRFPStageLst.RFPStage_ID = tblRFPManager.RFP_StageX) ON tblProposalStatusLst.ProposalStatus_ID = tblRFPManager.Prop_StatusX) LEFT JOIN tblEmployeeLst AS tblEmployeeLst_1 ON tblRFPManager.PID_Owner = tblEmployeeLst_1.Employee_ID) LEFT JOIN tblEmployeeLst ON tblRFPManager.PID_Creator = tblEmployeeLst.Employee_ID) ON tblJobTypeLst.JobType_ID = tblRFPManager.Job_TypeX) LEFT JOIN tblCustContactsLst ON tblRFPManager.CustContact = tblCustContactsLst.CustContacts_ID) ON tblSalesTypeLst.SalesType_ID = tblRFPManager.Sales_TypeX) ON tblCountryLst.Country_ID = tblRFPManager.Country_EndUserX) ON tblSolicitationTypeLst.RFPSubmittalType_ID = tblRFPManager.Solicitation_TypeX) ON tblBusinessTypeLst.BusinessType_ID = tblRFPManager.Business_TypeX) ON tblBidTypeLst.BidType_ID = tblRFPManager.Bid_TypeX) ON tblContractTypeLst.ContractType_ID = tblRFPManager.Contract_TypeX) ON tblApprovalClassificationLst.ValueClass_ID = tblRFPManager.Approval_LvlClassificationX) ON tblJobCatagoryLst.JobCatagory_ID = tblRFPManager.Job_CatagoryX
    ORDER BY tblRFPManager.RFPMgr_ID DESC;

  5. #5
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,702

  6. #6
    Preston is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2017
    Posts
    55
    I don't see any calculations or aggregation in that query.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. External Table is not in the expected format (error message)
    By rltidd27 in forum Import/Export Data
    Replies: 2
    Last Post: 03-13-2017, 08:29 PM
  2. Replies: 7
    Last Post: 03-17-2016, 05:53 PM
  3. Replies: 9
    Last Post: 09-26-2012, 12:20 PM
  4. Make Table Warning Message
    By cassidym in forum Queries
    Replies: 1
    Last Post: 03-16-2011, 10:12 AM
  5. Error Message after exporting MS Access Table
    By samjoseph in forum Access
    Replies: 1
    Last Post: 02-22-2010, 04:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums