I have created a query that populates a report.  The report is linked to a
button on a form.  I want the report to open to a specific record tied to the
record that is open on the form when you hit the button.
Here is what I have accomplished.  In the query, I know how to set it to

Hello
Im having trouble trying sort some data from a table and structuring it so it
can have our fiscal start date (July 1st) to a rolling current date  Im
writing in sql so I can use that query for a crystal report.

Here is a snipet of my query
UserID = [Returns Associates].[User ID]
It works like a charm, but what if I want the results to reflect all of the
User IDs?

I have an union query to create a report.
The union query sort by alphabetical.
For some reason, I need the order base on user entered.
Are there any way to set the result not sort in union query?

  I have a rather complex ( at least I think) SQL code I'm trying to run on
a form which decides the criteria for a report. Basically my form is set up
like this. We have about 10 different items to choose from each with a check
box next to it. If you put a check in the box ...

Why would I get a statement for the sql criteria in a query that reads "At
most one record can be returner from this subquery"
SQL:
(select   [tblPlatformCategories].[platformid] from [tblPlatformCategories]

I used the DateDiff Function
to return an answer as 1year 2months  5days
How can I seperate so each has their own column/field?
1 year 2 months 5 days(original column)

Need help with my query. I have 4 fields - Q1 Q2 Q3 Q4.  I'd like to be able
to have fields of totals for each quarter. I've tried going to each field -
View (on Menu), then TOTAL (replaced Group By with SUM) but it just replaces
the field name.  I'd like to be able to have the ...

I currently am using a query as the record source for a report that I run on
a regular basis. The particular report that I want generated currently uses
the Criteria of the query for and the Between [startdate] and [enddate]
commands for me to determine the date range that I want ...

I have two tables: NM_Members and CA_Members  
Both tables ID and Location fields.  
NM_Members.ID is a primary key and CA_Members foreign key and the join is
set for ALL records from NM_Member and only those records from CA_Members

How can I count the number of times a particular two-character code appears
in a work order.
I have a table of records and the work order number appears several times,
each time associated with a two-character code. I need to know how many times

I have 3 tables that i need that have some data that is the same.  I have
created 3 queries to pull this data.. one of them I do as a make table, then
the other 2 i do as append queries.  I created a macro to run each of these
queries in sequence of the make table, then the 2 ...

Hello, I have a table which includes [Sales_Person] and [Sales_Value] and
[Sales_Date] ...I have used a select query to list Sales person, Total Value
of Sales, Count of Sales, and Max Value of Sale, is there a way I could list
what month their best sale occurred in? or am I ...

I am new to Access. I have a table for daily issuance of a material from
warehouse. I am trying to create daily report but when the material is not
issued on a particular day the query return with no data, I would like the
query to return 0. Please suggest how to write the query ...

I need some help in creating this query.
I have a table "Customer"
CustomerId   CustomerName   CustomerStartDate   CustomerEndDate
====================================================