question

RamadasRavikumar-2512 avatar image
0 Votes"
RamadasRavikumar-2512 asked Criszhan-msft answered

Access, lookup for data in another table if matches update the current cell

In my access database i have two tables:

Master_Table
Material Return Data
In my material return data table , i need to update "complaint recived date" automatically based on the "complaint number"(both the column data is available in master table) & rest of the column data will entered manually. To update "complaint recived date" automatically based on the "complaint number" , I have entered below sql query in the row source of the column , while running the query it is showing correct data but in the table it is not updating , kindly help me.

 SELECT master_table.[Complaint Received On] FROM master_table WHERE (((master_table.[Complaint Number])=[Complaint_No])); 


SQL query entered as row source:
SbSQi.png


Query result:
eqqJJ.png
Dssc8.png

table image:
fKnZg.png



sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

In my access database i have two tables:


Do you mean a MS Access (from Office) database? I ask because you used the tag for "MS SQL Server", that's really something different.

Please post table design as DDL, some sample data as DML statement and the expected result.

0 Votes 0 ·

1 Answer

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered

Hello,

Welcome to Q&A!

The tag sql-server-general indicates that this is a zone for discussing SQL Server technical issues.
According to your description(access database ,Row Source) and the images provided, this question is more related to Microsoft Access, please ask this in relevant zone(office-access).

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.