query design view

  1. K

    NOT LIKE query in Access 2013 not working

    I work in MS Access almost exclusively in Design View because I have to do quick little queries often and it is fast and easy. With that caveat, I would prefer to have a solution in Design View if at all possible. I am trying to combine wildcard queries that are both "Like" and "Not Like". When...
    • kyleno
    • Thread
    • access 2013 combine not like query design view wildcard
    • Replies: 3
    • Forum: Microsoft Access
  2. A

    Question on query source and set up of workbook

    I have a workbook with several tabs. One tab is called master. I then have another tab called summary sheet. On the summary sheet i have several tables which are all queries looking into the master tab. This is all on one computer and works fine. however if i want to put it on a usb the...
    • ardykav
    • Thread
    • query design query design view query designer query editor
    • Replies: 3
    • Forum: Excel Questions
  3. R

    Access 2013 Query Question - Convert Date Value to YYYY-MM Format in Query Results

    Hi. I use MS Access 2013. I have a table the includes a date field. The format is Date/Time and dates are displayed in the field as mm/dd/yyyy (e.g. 01/31/2015) I want to be able to query on this field, but I want the query to return the YYYY-MM value for each date. For example, for date...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top