I have a check box that I want to use to view several text boxes if it is
selected on my report. Such as..If it is selected I want to make visable
three seprate text boxes, text box 1, text box 2 and so on. If it is not
selected I do not want these text boxes to show on my report ...

Is there a way to filter out all the values in a column that only appear
once, leaving just items that appear 2+ times? I know there's a way to get
rid of duplicates, but I haven't been able to find a feature that would do
the opposite. Thank you for your insight!

I have a sales report containing [PartNumber], [TransactionDate], [Qty],
[CostCenter], [UnitofMeasure], [TransactionAmount]  with data from the last
12 months. The table is linked to a report created in Crystal Report.
Creating a crosstab to sum [Qty] by month[TransactionDate] is ...

Hope this explains it....I have a table called Class Listing (classid, name,
etc ), another called registrations (actual registrations, class id, date
reg. , etc.).  I have classid linked between the tables and my queries run
just fine....I need to be able to change the info in ...

I am getting a syntax error when I tried to execute this query:
Field: rep_code: Right(remote_dm_salesforecast.rep_code,3)
Total: Group By
Append to: rep_code

I have a data base that has a tblstudent table, with a 1 to many
relationship with table tblPrograms. TblPrograms has a field that has
program codes (field prProgramCode) in it. I have another table
tblExceleratedClasses which lists all the program codes (field

I have a three table DB and i have created a query that shows all records
from the three tables. How do i make it that the query can only be viewed and
not edit?

Hello All, I need some help with creating a query to sum a total time of a
field.
I have a table called client services and have a query which pulls: date of
service, total time, and provider name. I would like to be able to create a

I am entering height, weights and age into a database and I want to
create a query which enables Access to automatically caluclate BMI
(two kinds depending upon the age of the kid)
Any suggestions on how to do this?

Hello, I need some help to generate a query that pulls information on from a
range of dates.
I have a table called "client services" fields include: client name, client
number, date of service, total time, type of service, provider name, location

I am comparing two tables of portfolio names, one for prior quarter and one
for current quarter.  I'd like to see which portfolios have dropped out of
the prior quarter's table and which portfolios are new in the current
quarter's table.  Is there a simple command to do this?  ...

I'm slowly getting to grips with SQL by forcing myself to write all my
queries diret in sql view.
One thing keeps cropping up.  I keep getting a message 'You tried to execute
a query that does not include the specified expression 'tblName.FieldName'

I have multiple records for the same person, some records have the email
field, others do not.  If I'm aggregating up how do I make sure I capture the
email address.  If I use SELECT FIRST(EMAIL) GROUP BY NAME and the email
address is the first record then I'm fine (same with ...

In the pricing part of our database we have numerous calculated fields i.e.
sub-totals and grand totals for various sections of the quote and the final
job costing.
We need to refer to these frequently and pull them into forms, letters,

I am trying to create a simple append query with the following SQL
code:
INSERT INTO [Lead Source Analysis] ( Account, Code, Owner, Field5,
Aircraft, Share, Country, Region, VP, Team )