I have 4 tables : budget, sales, buyings and other expenses. They all have
two fields in common : name of the restaurant and the type of expenses. I
would like to build a report that shows me, by type of expenses and then by
restaurant, the budget and the real values for each ...

I had several queries that worked fine. Somehow all the queries got changed
by Access to have As Expr1... As Expr2 etc. for every column in every query.
This has caused a web page to fail that was relying on the column names.
Does anyone know what would cause this to happen?

I need to perform inserts and deletes in several tables of my MDB in a form.
I'm using the command DoCmd.RunSQL = "..."
But i have a problem: when a do a delete statement, appears the mesage: "You
are going to delete x records... bla, bla. bla";

I have two tables:
taProperty
fldPropertyID PK
fldPropertyAddress

I am quite proficient with Excel, but relatively new to Access.  I suspect
there is an easy way to use an update query to get Access to delete an entire
row if a certain column has blanks, but I don't know how to do this.  The
reason for this is that some numbers are ...

I have a table of stores that have processed some templates of returns.  The
templates have the store number followed by numerous warehous locations.  So,
where the store number is 4031 and warehous location is P1xyz the template
number would look like "4031P1xyz".  What I want ...

I have created a query.
How can I send it to an email address?  Excel or Word format is fine.

In Design View - I am building an Enter Perameter Value option for the user
to pick in the value.  Example [Enter Division:].  However, I want the user
to be able to pick from a list of values for this field.  Is this an option?  
If so how do I build that in the Criteria?

Using: Classic ASP, MS Access, Jet SQL
I have a users table, an occupation table and a resolver for the n-n
relationship between the two first.
CREATE TABLE User (

Hoping someone can help me out, would be much appreciated. Here is
what I am trying to do:
I have several tables, each with 46,000 rows of data. I need to
analyze it in a couple of different ways. I am very strong with

I posted this in the wrong section, and am reposting it to the 'Queries'
help section:
Hello,
I am trying to write a query that will show me the Top 25 Brokers (by

I want to search for registration numbers within tables, these numbers may
have embedded spaces. Also the registration number typed into the search form
might include embedded spaces. Ideally I would like a LIKE command that
ignored spaces.

I have a Frontend on the PC of every user, a Backend with the tables on the
server.
The Frontend has also one table (which has unique records for every user)
I have this Query:

In the sample data below I have the problem that two identical vendor IDs
have different descriptions. How can I create a query that would isolate all
of the instances in which that happens?
Vendor ID    Vendor Descr

This is my first attempt at using dsum() in a query and I almost have it,
however, the running total is running in the wrong direction.
SELECT CustomerYTDSales.CUID, CustomerYTDSales.YTDSales,
DSum([YTDSales],"CustomerYTDSales") AS Expr1