Windows 10: MS Access can't create a new Querie

Hey,So I am trying to merge an Excel document and contacts from my laptop together into a Querie in MS Access. The needed data from the Excel doc does not appear in the query. The Excel and contacts have full access granted. It had been working, until I bought a new laptop with windows 11, afterwhich it stated showing me the followign error message. I'm at a loss, got any ideas?Thanks in advance for any tips,Paul Sudbrock

:)

 

MS ACCESS: A7 Building Queries in Microsoft Access

Hello, I'm having problems with creating a database from this questions. I was able to do get to a point but won't show or missing something. Can anyone help on these questions:

2. Display the CustomerNum, CustomerName, OwnerName, Phone, RestaurantType, and FirstContact of customers who were first contacted in 1992 and 1993. The list should be sorted by the FirstContact date (with the most recent at the top) within RestaurantType in ascending order.

3. Write this query in SQL. It should be your SQL code and not the one generated by Microsoft Access. Show the CustomerNum, OrderNum, and InvoiceAmt for orders that were placed by customers with CustomerNum in the 500s (that is numbers that fall between 500 and 599) or valued at $2,000 or more. Sort the list by CustomerNum in ascending order.

4. Write this query in SQL. It should be your SQL code and not the one generated by Microsoft Access. Show the CustomerNum, OrderNum, and InvoiceAmt for orders that were placed by customers with CustomerNum in the 500s (that is numbers that fall between 500 and 599) or valued at $2,000 or more. Sort the list by CustomerNum in ascending order.

5. Show the CustomerNum, OwnerName, Kitchen Area, InvoiceAmt, and ZipCode for customers who are located in ZipCodes starting with 43 and have InvoiceAmt between $1,200 and $2,000. The list should be sorted by CustomerNum.


Attached is the File on a zip as access file is not accepted.
The queries I'm working from that I made for some of these are Customer Query, Restaurant Type, Order Query 1.
Thanks this will be a lot of help as I've been trying to do this for the last 3 days.

 

MS Access - #NAME? error

Lately I've been forced to work with MS Access, not quite my own preference but I have no choice here. So I've been learning myself some access, going quite well. THough for the past days I've been frustrated by the #NAME? error. I'm trying to make a textbox which gets its data from a control source, works fine. However I want the default value to be a select max query. I made the query, which works perfectly. When I add the query to the default value field it tells me #NAME? though. Any way of entering the query fails. However, if I make a combobox or listbox and add the query it works just fine. Does anyone here happen to be some MS Access guru or simply know the answer to this issue?


I already found the attached piece of text (couldn't copy it so I made a screeny, damn PDF) it didn't help at all though.

 

How to import data from MS access database using MS Query wizard?

Hi

How to import data from a MS Access database by using MS QUERY wizard?Can anyone please help me with necessary steps?

Thank you.

<original title: Importing data>