Update Query to filll all blanks in a column

[zach9208]

Hello all.

I have a table that I am consistently adding records to. I have that part of my database complete and working.

However, I am looking to find out the proper way to setup a new update query. I need this update query to prompt me once for a specific date, and then it fills all the blanks within one column labeled "Trade Date".

I need this to quickly update all the records that I import from excel that have not been assigned a trade. I really need a query as it can be hundreds of records in a given day.

Any ideas? Thanks in advance!

 

[Micron]

did you try to create an update query by yourself, or at least try the query wizard? If this is one table without joins and defined relationships it should be as simple as

UPDATE tblYourTableName SET tblYourTableName.[Trade Date]=[Enter Date] WHERE tblYourTableName.[Trade Date] Is Null;

To be updated with that statement, the field has to have nothing in it, including a space.
You will probably get a prompt asking you to confirm that you are about to update n rows. Note that I did not (and NeVeR) use spaces in my made up table name.
When Access cannot process something in a sql statement that it thinks is a field or table name, it will prompt you for the value. So [Enter Date] is a parameter and the words within will become part of the prompt. That's the only time I would include spaces, and NeVeR would I use special characters except sometimes, the underscore. You might want to research reserved names and naming conventions.

 

[zach9208]

Thanks, Micron. This SQL code worked perfectly. I also looked into naming conventions to avoid. Thanks again for the help.

did you try to create an update query by yourself, or at least try the query wizard? If this is one table without joins and defined relationships it should be as simple as

UPDATE tblYourTableName SET tblYourTableName.[Trade Date]=[Enter Date] WHERE tblYourTableName.[Trade Date] Is Null;

To be updated with that statement, the field has to have nothing in it, including a space.
You will probably get a prompt asking you to confirm that you are about to update n rows. Note that I did not (and NeVeR) use spaces in my made up table name.
When Access cannot process something in a sql statement that it thinks is a field or table name, it will prompt you for the value. So [Enter Date] is a parameter and the words within will become part of the prompt. That's the only time I would include spaces, and NeVeR would I use special characters except sometimes, the underscore. You might want to research reserved names and naming conventions.

 

[Micron]

You're welcome. Here's a pretty comprehensive list of "bad" words: Microsoft Access tips: Problem names and reserved words in Access
and one example of a naming convention :General: Commonly used naming conventions
(which I never adopted 100%. I use qry for all queries, and let the symbols in the nav pane tell me which type it is - but you can't see that when coding. Too late to change now!)