I am having trouble figuring out how to show columns and rows in cross
tab reports that dont have any data within the table. I am not sure
this makes sense but for example if I am making a crosstab report with
the colums being the sales teams and the rows being the industry and

I have a query that pulls contact data for clients. Currently, I have users
run the query directly from a form into which they enter the data.  This way,
I can limit the query by using an ID parameter from the form so that the
records are only for the particular client they just ...

I have a table with approx. 400000 entries. Each record in table has a unique
identifying number I need to select approx. 250 of these records by their
individual id number.  I have identified the actual record ID's I need and
they are in a separate excel .xls. How can I write a ...

I am trying to set up a query (access 2003) using two columns.  One column
'date of referral' and other column 'date of assessment'.  Need to pull out
people who have gone over 15 day wait from referral to assessment. Is this
possible as referral dates/assessment dates are ...

I have a table in access that needs to be exported to an Excel spreadsheet.
One of the requested design specifications for the resulting spreadsheet is
that it not contain empty columns. (No columns with Null fields)
Currently I am manually deleting them in Excel and this is ...

Good Morning,
Could anyone tell me how to write an expression in a query to basically say
"No Duplicates" I only want to use this in one coloumn.
Cheers

I have a switchboard that has a button for Reports, the Reports switchboard
has a selection of reports.  One of the reports is called "Detail by Specific
Employee." When this button is clicked, I'd like the report (in print
preview) to show for that specific employee.

I am trying to add sums at the bottom of my reports that are generated
from crosstab queries. I tried the usual =sum(Input) and it doesnt
seem to work.

I'm trying to create a field, LsDays, where a calculation is made like this...
Lstock Day1 Day2 Day3 Day4 LsDays
75       25     20     30     10      3.0
In other words LsDays is telling me how many days stock I've got. Days1-4

I am trying to get my crosstab query to display zeros where there are
no values. I cannot figure out where to put the expression

Does the "IIf" command work if I have a number of different cases, each of
which need to call out a different result? If so, what is the syntax for it?
Is there a limit to the number of cases I might be able to have?
I am trying to enter a new column in a query called "Zone" that ...

I'm doing a POS database for a restaurant, and I'm stuck! I really need some
help!!!
I have Table1 with the orders and their costs and Table2 with all the extra
ingredientes for each platter ordered. Table1 and Table2 are related through

Using Access 2003.  SQL for my query is below in case it helps but I use the
query grid.  My ultimate goal is to get a total count of each type of
therapy in each area.  My query is showing all the appropriate records but I
don't have a total of each therapy, instead if there is ...

I am having trouble and have been dfor some time with sorting out this issue
i am having with concatenating.
I have taken a look Duane Hookams example on this and found it helpful but
need to refer and concatenate a field in a seperate table. I have taken a

I have created a simple sql statement that displays a couple of columns from
the first table based one column being equal in both linked excel tables and
another column not equal. It is the not equal that does not seem to work and
it looks like there is trailing space in this ...