Solved Deleted

[LarryE]

Deleted

 

[GPGeorge]

I was able to create and use an append query today, after installing updates from yesterday.

My installed version is M365 32 bit and MS365 64 bit (Current Channel)

What version do you have installed?

 

[LarryE]

I was able to create and use an append query today, after installing updates from yesterday.

My installed version is M365 32 bit and MS365 64 bit (Current Channel)
View attachment 122573

What version do you have installed?

I'm a half-wtted moron. I screwed up with the fields. Everything is fine....

 

[theDBguy]

INSERT INTO Fund
SELECT DISTINCT
FROM FundAccountCashBalance
ORDER BY FundAccountCashBalance.FundAccountNumber;

Just checking, don't you need to include the field list to append?

 

[LarryE]

Just checking, don't you need to include the field list to append?

Yes. See post 3. Sometimes old age gets the better of me.

 

[theDBguy]

Yes. See post 3. Sometimes old age gets the better of me.

Saw it. I was typing when you were posting...

 

[GPGeorge]

I'm a half-wtted moron. I screwed up with the fields. Everything is fine....

I would say you are pretty normal, except more honest than some about openly acknowledging mistakes.

 

[LarryE]

I would say you are pretty normal, except more honest than some about openly acknowledging mistakes.

Well even though I have all my wits, half are Visible=No and those that are visible half are Enabled=No....