SQL Not a Valid Alias Name Error - Microsoft Community

i have query named: qrygrievancetrackingform has following sql revised longer sql because getting error: not valid alias name.  revised original sql correct table names from: [grievance tracking system] to: tblgrievancetrackingsystem , from: members tblmembers.  before beginning rename 2 table in original query, i got an: inner join error when opened query in design view.  i think corrected inner join error.  now, i'm getting error: not valid alias name.  after clicking ok insertion goes to beginning of: tblgrievancetrackingsystem.*,.

i've read many different things error: use quotation marks; use brackets and; you cannot have field name that's in table that's same table name.

i'm using: tblgrievancetrackingsystem.*, tblmembers.*, can query grid , attempt correct problems there , because wanted retain the time intervals created.  read: "when want include fields data source, can either list fields individually in select clause, or can use asterisk wildcard character (*)."  help, robert.

select tblmembers.*, tblgrievancetrackingsystem.*, dateadd("d",14,[incidentdate]) [last day discuss @ informal a], dateadd("d",7,[discusseddate]) [last day appeal step a], dateadd("d",7,[dateappealedformalstepa]) [last day step meeting], dateadd("d",7,[formalstepameetingdate]) [last day appeal step b], datediff("d",[pdidate],[disciplinedated]) [time interval-pdi date/date discipline dated], datediff("d",[pdidate],[datedisciplinereceived]) [time interval-pdi date/date discipline received], datediff("d",[pdidate],[discusseddate]) [time interval-pdi date/date discussed], datediff("d",[pdidate],[dateresolvedinformalstepa]) [time interval-pdi date/date resolved informal step a], datediff("d",[pdidate],[dateappealedformalstepa]) [time interval-pdi date/date appealed formal step a], datediff("d",[pdidate],[formalstepameetingdate]) [time interval-pdi date/step meeting], datediff("d",[pdidate],[stepadecisiondate]) [time interval-pdi date/step decision date], datediff("d",[pdidate],[dateresolvedformalstepa]) [time interval-pdi date/date resolved step a], datediff("d",[pdidate],[stepbappealdate]) [time interval-pdi date/step b appeal date], datediff("d",[pdidate],[uspstrackingdatedelivered]) [time interval-pdi date/date step b appeal delivered step b team], datediff("d",[pdidate],[datereceivedatstepb]) [time interval-pdi date/date step b appeal received], datediff("d",[pdidate],[stepbdecisiondate]) [time interval-pdi date/date step b decision/impasse], datediff("d",[pdidate],[dateappealedarbitration]) [time interval-pdi date/date step b impasse appealed arbitration], datediff("d",[pdidate],[dateregionalarbitrationscheduled]) [time interval-pdi date/date step b impasse regional arb scheduled], datediff("d",[pdidate],[dateprearbagreement]) [time interval-pdi date/date step b impasse pre-arb agreement], datediff("d",[pdidate],[dateregionalarbaward]) [time interval-pdi date/date step b impasse regional arb award], datediff("d",[pdidate],[dateappealednationalarbitration]) [time interval-pdi date/date step b impasse appealed national arbitration], datediff("d",[pdidate],[datenationalarbitrationscheduled]) [time interval-pdi date/date step b impasse national arbitration scheduled], datediff("d",[pdidate],[datenationalarbaward]) [time interval-pdi date/date step b impasse national arb award], datediff("d",[incidentdate],[disciplinedated]) [time interval-incidentdate/date discipline dated], datediff("d",[incidentdate],[datedisciplinereceived]) [time interval-incidentdate/date discipline received], datediff("d",[incidentdate],[discusseddate]) [time interval-incidentdate/date discussed], datediff("d",[incidentdate],[dateresolvedinformalstepa]) [time interval-incidentdate/date resolved informal step a], datediff("d",[incidentdate],[dateappealedformalstepa]) [time interval-incidentdate/date appealed formal step a], datediff("d",[incidentdate],[formalstepameetingdate]) [time interval-incidentdate/step meeting], datediff("d",[incidentdate],[stepadecisiondate]) [time interval-incidentdate/step decision date], datediff("d",[incidentdate],[dateresolvedformalstepa]) [time interval-incidentdate/date resolved step a], datediff("d",[incidentdate],[stepbappealdate]) [time interval-incidentdate/step b appeal date], datediff("d",[incidentdate],[uspstrackingdatedelivered]) [time interval-incidentdate/date step b appeal delivered step b team], datediff("d",[incidentdate],[datereceivedatstepb]) [time interval-incidentdate/date step b appeal received], datediff("d",[incidentdate],[stepbdecisiondate]) [time interval-incidentdate/date step b decision/impasse], datediff("d",[incidentdate],[dateappealedarbitration]) [time interval-incidentdate/date step b impasse appealed regioal arbitration], datediff("d",[incidentdate],[dateregionalarbitrationscheduled]) [time interval-incidentdate/date step b impasse regional arb scheduled], datediff("d",[incidentdate],[dateprearbagreement]) [time interval-incidentdate/date step b impasse pre-arb agreement], datediff("d",[incidentdate],[dateregionalarbaward]) [time interval-incidentdate/date step b impasse regional arb award], datediff("d",[incidentdate],[dateappealednationalarbitration]) [time interval-incidentdate/date step b impasse appealed national arbitration], datediff("d",[incidentdate],[datenationalarbitrationscheduled]) [time interval-incidentdate/date step b impasse national arbitration scheduled], datediff("d",[incidentdate],[datenationalarbaward]) [time interval-incidentdate/date step b impasse national arb award], datediff("d",[discusseddate],[dateappealedformalstepa]) [time interval-date discussed/date step appeal], datediff("d",[discusseddate],[formalstepameetingdate]) [time interval-date discussed/date step meeting], datediff("d",[discusseddate],[stepadecisiondate]) [time interval-date discussed/date step decision], datediff("d",[discusseddate],[dateresolvedformalstepa]) [time interval-date discussed/date resolved step a], datediff("d",[discusseddate],[stepbappealdate]) [time interval-date discussed/date step b appeal], datediff("d",[discusseddate],[uspstrackingdatedelivered]) [time interval-date discussed/date step b appeal delivered step b team], datediff("d",[discusseddate],[datereceivedatstepb]) [time interval-date discussed/date step b appeal received], datediff("d",[discusseddate],[stepbdecisiondate]) [time interval-date discussed/date step b decision/impasse], datediff("d",[discusseddate],[dateappealedarbitration]) [time interval-date discussed/date step b impasse appealed regional arbitration], datediff("d",[discusseddate],[dateregionalarbitrationscheduled]) [time interval-date discussed/date step b impasse regional arb scheduled], datediff("d",[discusseddate],[dateprearbagreement]) [time interval-date discussed/date step b impasse pre-arb agreement], datediff("d",[discusseddate],[dateregionalarbaward]) [time interval-date discussed/date step b impasse regional arb award], datediff("d",[discusseddate],[dateappealednationalarbitration]) [time interval-date discussed/date step b impasse appealed national arbitration], datediff("d",[discusseddate],[datenationalarbitrationscheduled]) [time interval-date discussed/date step b impasse national arbitration scheduled], datediff("d",[discusseddate],[datenationalarbaward]) [time interval-date discussed/date step b impasse national arbitration award], datediff("d",[dateappealedformalstepa],[formalstepameetingdate]) [time interval-date appealed step a/date formal step meeting], datediff("d",[dateappealedformalstepa],[stepadecisiondate]) [time interval-date appealed step a/date step decision], datediff("d",[dateappealedformalstepa],[dateresolvedformalstepa]) [time interval-date appealed step a/date resolved step a], datediff("d",[dateappealedformalstepa],[stepbappealdate]) [time interval-date appealed step a/date step b appeal], datediff("d",[dateappealedformalstepa],[uspstrackingdatedelivered]) [time interval-date appealed step a/date step b appeal delivered step b team], datediff("d",[dateappealedformalstepa],[datereceivedatstepb]) [time interval-date appealed step a/date step b received appeal], datediff("d",[dateappealedformalstepa],[stepbdecisiondate]) [time interval-date appealed step a/date step b decision/impasse], datediff("d",[dateappealedformalstepa],[dateappealedarbitration]) [time interval-date appealed step a/date step b impasse appealed regional arbitration], datediff("d",[dateappealedformalstepa],[dateregionalarbitrationscheduled]) [time interval-date appealed step a/date step b impasse regional arb scheduled], datediff("d",[dateappealedformalstepa],[dateprearbagreement]) [time interval-date appealed step a/date step b impasse pre-arb agreement], datediff("d",[dateappealedformalstepa],[dateregionalarbaward]) [time interval-date appealed step a/date step b impasse regional arb award], datediff("d",[dateappealedformalstepa],[dateappealednationalarbitration]) [time interval-date appealed step a/date step b impasse appealed national arbitration], datediff("d",[dateappealedformalstepa],[datenationalarbitrationscheduled]) [time interval-date appealed step a/date step b impasse national arbitration scheduled], datediff("d",[dateappealedformalstepa],[datenationalarbaward]) [time interval-date appealed step a/date national arbitration award], datediff("d",[formalstepameetingdate],[stepadecisiondate]) [time interval-date step meeting/date step decision], datediff("d",[formalstepameetingdate],[dateresolvedformalstepa]) [time interval-date step meeting/date step resolved], datediff("d",[formalstepameetingdate],[stepbappealdate]) [time interval-date step meeting/date step b appeal], datediff("d",[formalstepameetingdate],[uspstrackingdatedelivered]) [time interval-date step meeting/date step b appeal delivered step b team], datediff("d",[formalstepameetingdate],[datereceivedatstepb]) [time interval-date step meeting/date step b appeal received], datediff("d",[formalstepameetingdate],[stepbdecisiondate]) [time interval-date step meeting/date step b decision/impasse], datediff("d",[formalstepameetingdate],[dateappealedarbitration]) [time interval-date step meeting/date step b impasse appealed regional arbitration], datediff("d",[formalstepameetingdate],[dateregionalarbitrationscheduled]) [time interval-date step meeting/date regional arbitration scheduled], datediff("d",[formalstepameetingdate],[dateprearbagreement]) [time interval-date step meeting/date step b impasse pre-arb agreement], datediff("d",[formalstepameetingdate],[dateregionalarbaward]) [time interval-date step meeting/date step b impasse regional arb award], datediff("d",[formalstepameetingdate],[dateappealednationalarbitration]) [time interval-date step meeting/date step b impasse appealed national arbitration], datediff("d",[formalstepameetingdate],[datenationalarbitrationscheduled]) [time interval-date step meeting/date step b impasse national arbitration scheduled], datediff("d",[formalstepameetingdate],[datenationalarbaward]) [time interval-date step meeting/date national arbitration award], datediff("d",[stepbappealdate],[uspstrackingdatedelivered]) [time interval-date step b appeal/date step b appeal delivered step b team], datediff("d",[stepbappealdate],[datereceivedatstepb]) [time interval-date step b appeal/date step b received date], datediff("d",[stepbappealdate],[stepbdecisiondate]) [time interval-date step b appeal/date step b decision/impasse], datediff("d",[stepbappealdate],[dateappealedarbitration]) [time interval-date step b appeal/date step b impasse appealed regional arbitration], datediff("d",[stepbappealdate],[dateregionalarbitrationscheduled]) [time interval-date step b appeal/date step b impasse regional arb scheduled], datediff("d",[stepbappealdate],[dateprearbagreement]) [time interval-date step b appeal/date step b impasse pre-arb agreement], datediff("d",[stepbappealdate],[dateregionalarbaward]) [time interval-date step b appeal/date step b impasse regional arb award], datediff("d",[stepbappealdate],[dateappealednationalarbitration]) [time interval-date step b appeal/date step b impasse appealed national arbitration], datediff("d",[stepbappealdate],[datenationalarbitrationscheduled]) [time interval-date step b appeal/date step b impasse national arbitration scheduled], datediff("d",[stepbappealdate],[datenationalarbaward]) [time interval-date step b appeal/date national arbitration award]
tblmembers inner join tblgrievancetrackingsystem on tblmembers.memberid = tblgrievancetrackingsystem.memberid;

i revised original sql correct table names from: [grievance tracking system] to: tblgrievancetrackingsystem , from: members tblmembers.  before beginning rename 2 table in original query, i got an: inner join error when opened query in design view.  i think corrected inner join error.  now, i'm getting error: not valid alias name.  after clicking ok insertion goes to beginning of: tblgrievancetrackingsystem.*,.

what actual table names -- they tblmembers and  tblgrievancetrackingsystem else?

try revising query --

select dateadd("d",14,[incidentdate]) [last day discuss @ informal a], dateadd("d",7,[discusseddate]) ....   , see if runs.

i not using slashes in names underscore instead.

Office / Access / Windows other