98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Delete Query
Delete Query
Resolved · Urgent Priority · Version 2007
Tue 18 Aug 2009, 10:27Delegate James said...
James has attended:
Access Intermediate course
Delete Query
Hey,
I have uploaded some data from excel into a massive spreadsheet and unfortunately the data I uploaded was slighly wrong.
The data was as below
Date, Month, Year, Total
Yet year is blank for a number of entries so I need to delete it , yet if I write into the criteria = "" it says Data mismatch in criteria expression.
Any ideas?
Cheers
James
Tue 18 Aug 2009, 13:32Trainer Simon said...
RE: Delete Query
Hi James,
Thank you for your question.
In the query window write the word 'Null' on the criteria line under the year field, run the query and that should bring up all the records that have no year associated with them.
I hope this answers your question.
Regards
Simon
Tue 25 Aug 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Insert The Current DateTo insert the current date into a Table field or Form Text box use: |
