Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Delete Query

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Delete Query

Resolved · Urgent Priority · Version 2007

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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.

Access articles

· Guide To Adding A Text Box Form Control In Access 2010
· Repetitive Tasks? Let Access Do The Hard Work For You
· Getting To Grips With Templates In Access 2007
· How To Create A Combo Control On An Access Form
· Access VBA Training Adds Power to your Databases

Please browse our web site to find out more about
access.training and other Microsoft training courses.

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips