Hi All. I am trying to design a query for a quarterly report. This is the syntax I have used. ("datereceived"=#01/01/2005# And...

I have a query set up to search for a specific date range. I have data on week 12/26/08-01/01/09and that works just fine. I also have data from...

I want to set up a query that will allow me to enter a begin and end date, but will pull the dates from data in 10 separate fields. i.e., The database has...

I've created 3 queries to determine which files are due within 1 week, 2 week and 3 weeks. The code i put in the query for files due in 1 week is the...

I have a database where I am attempting to create a complex weekly report for employee production. I am struggling with the date portion of this project. The...

I have two tables. Table A with a field with Date A in and Table B with two fields with Date B and Date C (start and end dates). I want to combine these and...

I have a table with expense details *EmployeeID, Amount, Company,Date*. A table with Employee info *EmployeeID, First, Last, Address, Supervisor*. A table...

OK, I've spent enough time trying to get this query to work. Time to call in the experts. I want a parameter query inviting the user to select records by a...

I am trying to create a query using a date range parameter that will pull just by month not by year and is ascending order. The criteria I used was Between ...

I'm having problems with date range queries. Can I make these queries when the person who built the database used "Text" as the "data type" for the date...

How would you make a query that would list all the dates occurring between Date1 and Date2 , including Date1 and Date2? Thanks, Billiam

Hi List, Im a first time poster, and new to access. But I have used sql in the past. I have a table called tasks listing all tasks (complete or not). What I...

I would like the query to display product under warranty for 90 days from the repair date(s) and display product that have expired past the 90 day warranty...

Hi My job currently requires me to enter data from 300+ forms a month. The system which we used in Excel was slow , and theprevious guy had three workbooks...

I have a date input field. I would like to run a query that allows me to choose a date range and have it return all records whose date input field fall into...

I have a report that is based on a query. The user inputs a date range into a form with this in the query criteria Between !! And !! The date that the...

Hello, I'm trying to perform a query on a set of data over a date range. The date field is in a date/time format of seconds starting from 00:00:00 01.01.1970....

I am working on an expenses database for a small family business. For each expense I have a start date and end date. I have the database then “normalize�...

I have a subfrm linked to a main form using an employee code. I designed the report to reflect these details. I have a print preview button on the main form...

I am using the following SQL Statement in my Access Query. SELECT ., . , ., . FROM Account INNER JOIN PrincipalPayments ON . =. WHERE (((.)= And (.)) And...