I have a issue tracking database that list users when an item is assigned and
then reassigned to a user group.  Well the issue can be reassigned several
times.  I only want to show the current reassignment.  I have a query that
has many of the same id number but the date and ...

Table A contains the following fields
Transaction Date
Account Number
Location

I have a text box called:
[Forms]![query form]![txtSearchDate]
I have a query that I want this text box to feed.  I want the query to
look at everything that is greater than the entered date.

I am fairly new to access.  I was wondering how to get information from
1 column on 1 table to sort for 2 date ranges found on a form into 1
query to sent to 1 report.  Please help as this issue is about to run
me into the ground.  I have tried two queries into one.  With the each

Using the LIKE and [PROMPT] Features together.
====
I am currently designing a pretty standard database. It contains three
tables, a customer details, sales details and Product details.

I have a query that takes dates from a Form
Between [Forms].[Startup].[txtDateFrom] And [Forms].[Startup].[txtDateTo]
The query runs as expected as long as the form is active with dates in the
required fields.

I am trying to rank some data using 5 columns as sub categories as follows:
Calender Year (yes, I know that it is spelled wrong)
Calender Month
Platform

My user gives me startDate and finishDate as input.
I want to group my data by weeks where:
First week first day is startDate
Last week last day is finishDate

I have a dropdown that is populated by the following query - but it
doesn't do what I want.
SELECT DISTINCT [Division group cross table].Division
FROM [Division group cross table] UNION select '(All)' from [division

Could someone please tell me how to change a field type from memo to text in
a make table query?  I am willing to create a new column/field name to get
this done.
Thank you.

I have a series of Crosstab queries based on one large query, with a month
field that changes frequently.  I want the user to be able to enter the month
in a form, and then run the crosstab.  The back-end query works great, but
the crosstab fails because the Jet database engine ...

I am trying to use the results from a form to build an SQL Query.  The form
has combo box's to select a value that is updated to a table that is in turn
used as the selection criteria of the query.  When I select a value the
criteria in the query works fine.  When the selection ...

I am trying to convert the current date "Now()" into a julian date (yyddd) in
a query field.

I'm trying to delete records in Table 1 (Appointments) which are linked to
Table 2 (Leads). So I created a query that says:
DELETE Appointments.*, Appointments.ApptStatus, Leads.Updated, Leads.Source
FROM Appointments INNER JOIN Leads ON Appointments.LeadID = Leads.LeadID

I am trying to find the least recent date of four date fields in a
query. Is there a way to do this?  I'm lost.
Thanks for your help!
jb