What would be the proper syntax for a query to return the records for the current month? I would like it to work like date() but for the month. Thanks.

My database needs to run a report that will give the total number of each specific type of inspection given a user-defined date range. I have about 15...

I use a form to search a text field in a query The SQL view of the query looks like this SELECT qryMainRefList.YR, qryMainRefList.TI,...

Hallo, How can a i use 01-01-year(date()) in my query for date calculation. e.g. = 01-01-year(date()) and =DateField Tried "01-01-"&year(date()) but that...

I run ten queries each week , each of them has a variable (date) that needs to be changed before i run the query. This means that I have to go into each of...

Hi All, Can anyone tell me the correct syntax for preforming the Like operation with a wildcard where the text to be searched for comes from a control on a...

I have a query that checks to see whether a record already exists in a particular table. The result if it does is that Expr1 = -1 My question is how do I...

I want to aggregate date data into weeks of the year. I have checked all date/time function and I can't seem to locate these types of functions. Seems strange...

Hey guys... Thanks so much. Van... I put in your code and it worked. I HAVE ONE PROBLEM THOUGH. Below is actual output from query (except frist 2...

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

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

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

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

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

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

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

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

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

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