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

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

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

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

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

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

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

I am having trouble with criteria in my query. I'm trying to use an expression but keep getting a syntax error. The expression for the GroupID field in the...

Hi guys. I'm using Access 97 (SP2) to do some work for a client. I am running a Union Query on two tables tht are identical, to create one set of data. Here...

I Got a Query that is Calculating the True Average of the 5 Days of the Week by Product. What happen is, some products can be 0 at the end of the week(Product...

Terry I have responded in the original thread to this topic Gerald Stanley MCSD -----Original Message----- Hi, I need to devise a query that will diplay...

hi everyone, I have a report in an adp that uses aggregate functions in its record source and I am trying to figure out how to filter the records displayed in...

I know this is probably and easy one, I have done it before, but blanking out now. I have a date/time field (DateShipped) and I am creating a query from the...

I want to add a calculated field to a table. In Excel I simply write a function: (i.e. add three columns and write the result in the fourth). Apparently it's...

For starters, you are not putting spaces between the different words. Add a space at the end of each text string on each code line. For example, "From...

Hi all, This should probably go into the .net newsgroup as well. I am using an Access 97 database (I have no control over this - it is part of a package...

Hi everyone I have two tables. All incoming data goes into Table A. Table B are certain records from Table A. What happens is that some data goes into...

I have a query with the following fields: date, invoice, client, expenses, hours. I need to know the total of the invoice (and expenses and hours) between...