Hello, how would you execute multiple queries at one in the Query Window. When I run the two lines below I get the following message. syntax error (missing...

What is the SQL statement for queries by keywords? such as searching for records of last names begin w/ letter N

Is there some method that will allow me to save an existing query as a table? Thanks, JR

I am creating a mail merge document from a database. My table currently includes First Name, Last Name, Title, Institution, Address(work) City(work),...

I would like to use QBF but it adds records to the table. What am I doing wrong? I remove the filter. Thanks. Environment: Access 2000 Form with tabs and...

Hello, I have an MDE database that runs a make-table query via a macro that starts as part of some VBA code. It had been working just fine. However, for some...

Hi, How can I access existing query with one parameter from VBA code. There is no problem to access table or simple query from the code. OpenRecordset using...

Hello to all, I am getting a strange problem some dates function thatI never had before, I am getting this following message " Function is not available in...

Hi, I have a query in a DAO recordset which have the parameter Between and . The dates have the British format "dd/mm/yyyy" (my fields are saved in the...

Good morning, I have a query that is giving me a data type mismatch error. I do not have join relationships. However, I do have a query criteria that should...

Hi, i have a table called receipts in which i store the past 12 receipts a client has paid. i want a way to find any receipt from a particular month (say for...

I am trying to run a crosstab query based on the answer of a query that has a select statement in the criteria for a date range. The crosstab query says it...

If I want to make an IIf statement that hinges more than two situations (say three or four possible outcomes), is it possible to embed IIF statements inside...

I have a querry named "reminder labels" that get data from "Service tabel" & "Customer Tabel' what i need to do is have the querry get the newest service date...

I have a very simple database, storing information for production Kanban cards. The user inputs how many cards there are (ie. 1 to 12) and many other fields,...

I am trying to create an Access dB with tables imported from an Oracle dB....ultimately the data extracted from the Access dB will be in Excel and dB4...

Hi, I have a query (below) that is returning a text string. This query will then drive a crosstab query. in the dynaset, a few of the records are returning...

I have a table that contains the following information: Auto ID, PersonName, EventName, EventDate PersonName, EventName, and EventDate are not unique. There...

Below is a query that shows "CarePlans" for all active customers. It only shows careplans that exist between "MonthStartDate" and "MonthEndDate" which Is...

Hi, this is an excel/access question. i was wondering how to make excel run a querry in access and put the result of the querry into a spreadsheet. thanx a lot