I need to output data and am lost on how-to achieve it.
I have 2 tables: Billing and Extras.  Each project can have multiple entries
in the Billing table, but only one entry in the Extras table.  The structure
of each table is very similar

Need help once again. I ‘m trying to create a new db from one that someone
else did. The old db only had one table (cry). The fields are:
ID –PK (autonumber)
Box Number

I have a table containing 2 types of record, the type indicated by a certain
column.
There will always be only one record of each type with a common key.
I need to create a query where I combine each pair of rows into a single row.

I have a (vehicle Identification Number) VIN field that has 17 digits in it.
I have a shortcut search that uses the last 8 of the VIN and a Car's Make to
do a lookup.
SOMETIMES there are duplicates of the last8 & Make and what I'd like to do is

I have an issue that popped up in the last couple weeks. Both work and home
using Office Pro 2003 SP3, Access 2003. Before around 3/20 I was able to
select an append query with the destination table included as part of the
query (inner join, with 'is null' on the primary keys). I ...

I have a query that includes: Year column formatted as "yyyy", month column
formatted as "mm", and total sales per month. I am trying to get the top 5
months for every year. Is there a way to do that. Access provides only to
show the top over all and this is not what I want.

I have a table containing a long list of dates.  Each date represnets a visit
to a particular job.  Each date also represents a payment.  I could have the
following visits in a month, say 1st April 2009, 14th April 2009, 15th April
2009, and 24th April 2009.  These set of dates ...

I have to make a query based on two Tables, Table 1 (Flight_Input) contains
events for a list of individuals. Table 2 (Pilots) contains a list of
individuals with four additional columns, these four columns are Start and
End dates for two semi-annual periods that are based on ...

I am trying to add a crosstab query to a subform and am receiving the
following error message: "You can't use a pass-through query or a
non-fixed-column crosstab query as a record source for a subform or
subreport.  Before you bind the subform or subreport to a crosstab query, ...

I am creating a query off of a single table. One column/field in the database
contains a vendor code that consists of a five-character name. I want the
query to bring back all records for all vendors, except for 6 distinct
vendors.

Below is my union query.  The problem i'm having is that it omits two fields
from the three base queries (Num) and (Den).  I feel like i'm just on the
edge of figuring this out but every combination i try won't run.  How can i
add the Num & Den fields to my union query result?

I have created a query that pulls information from two linked tables. There
are three fields Date, Item and Plate count. I am trying to put a plate count
in with a date range. Example
0 - 90=12 / 91 - 180=15 / 181 - 270=25 / 271 - 365=98 / >365=25

I can't seem to get the syntax right for an insert query. In Sql Server I
would do this:
INSERT INTO [bla] (a, b, c)
SELECT 0, 'foo', NULL

I work for a non-profit that gives people money for Gas, Rent, Food, ect.  I
built a simple table with each category in a field.  I need a report that
sums each category and totals all money spent for a specific period.  With
help from Karl (from here) I was able to build a query ...

I thought I had posted this question before, but I don't see it on the
forum.
I'm managing a db with (amongst many others) two tables; one for
tracking when we do a repair / change control on one of our servers,