I have multiple rows of schools that are in the same building. For each
building, I want to concatenate each school name and put a pipe (|) between
each one.
I found this link (I was planning on working out the pipe (|) bit later):

I have a basic query that should return all records in the database (I only
have 9 records thus far for testing purposes). It asks for data from fields
that each record has data for. Problem is that I'm only getting 8 of the
records returned when I run the query. Thinking it ...

The query is based on two main tables.  On table has two smaller tables that
are linked.  The other table has just one table linked. I have the
relationships established and have inputed data in the tables.  I cannot get
the query to run as I get the error message.  I have tried ...

Hi. I have "inherited" a database that tracks a number of individuals'
information.
However, some flaws exist and I'm trying to figure out how to fix them.
I'm trying to create a function that will total the number of individuals in

I currently have a group of queries appending employee timesheet data from
linked excel tables into one main table.  
I have set it up so that all these queries run under one macro, idealy this
macro will  be run once a month to add that months timesheet data into the

I have a query that I want to run from a form. If you select All for each
field (yes/no fields) it will filter for those values. If I select All how do
I make it not filter?

I have a macro that automatically exports all e-mails in a folder to text,
and another that puts each item into a field in Excel, and a third that
imports them into a table in access.  That all works great.
Now I need to match the last word in a text field with another table, for

I would like to display data for the weeks not recorded to make a
graph.
For example I collect the following data:
Start Date   Start Date Week          End Date        End Date Week

I have been struggling with this one for the past week and I’m at my wits
end. Please help!
I have a log table that I need to find all transactions where the
transaction type is “Update Item” and the previous entry for the same serial

I'm very new to access and have been trying to teach myself using the help
facility, but I'm now stuck and could use some advice.
I am creating a database of employee timesheets.  I receive 20 excel
timesheets per month.  Each of these timesheets has the number of hours and

How can I have the three separate Tables that have nothing in common? I want
to combine them into one column? How can I do this?
Example:
[123WeeklyAdminData].emp_name,

this is apparently the easiest question..ohh please help me
how do i find the total price of all stock items in the database.. it says
here (use total query and find the SUM of the price of the stock) <-- i can
do that.. the answer is $157.. but thats only for one of each item... ...

How do I override the wildcard search when I need to reference a value that
has the literal * in it.  I am searching for anything that has a code of
"A*".  I get any code starting with an A (e.g. A+, A-,A*, etc)

I like to get result of net banlance from two tables opening balance and
Transfer.
What should be condition in query?
Opening Balance:                                     Transfer:

Good Evening, I have a existing records this:
Date                 Time
10/05/2008       10:30:28
10/05/2008       00:12:55