Append one record " Salesinvoiceappend " (1 Viewer)

Safari

Member
Local time
Today, 06:08
Joined
Jun 14, 2021
Messages
95
HI ALL

MY QUERY NAMED " Salesinvoiceappend " IS NOT WORKING AT ALL
AND I DONT KNOW WHY ?
CAN ANY ONE CHECK IT
AND MAKE IT RUN

I WANT :-

IF THE TABLE TBLGL NOT CONTAINS " INVOICEID " AND NOT CONTAINS "GOODID" THEN RUN QUERY AND APPEND THE RECORD .

THANKS
 

Attachments

  • TESTAPPEND.accdb
    4.3 MB · Views: 192

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:08
Joined
May 7, 2009
Messages
19,245
i think your query is meaningless?
 

Safari

Member
Local time
Today, 06:08
Joined
Jun 14, 2021
Messages
95
why my query is meanless ?
any way can we do it and run query to collect all data from diffrent tables in one table ?
 
Last edited:

Users who are viewing this thread

Top Bottom