I am trying to create a report that has data from two different queries that
is associated by a primary key (both queries have the primary key information
in them).  What I am trying to accomplish is that I have the main report
(approx 102 records) but want to associate data from ...

I have a table with the following logical structure:
Name   Number of apples     Number of oranges     Total fruits
Mike            3                              2                            
      5                          

My problem:
I have datas like
A    B
A001    2007-10-01

I have a query where I want to search multiple fields.  I may want to search
criteria in all fields, or only one field.  I searched the bulletin board and
learned that I need to place each criteria for each field on a different
line, which I've done.  My "Where" sequel statement ...

I have  table with a field like this one and I need to separate the dollar
amount out, the amoount can range from 3 digit to 6 digit or more.
XY4567 Converter belt $3.40 or 7890 Transmission $1250.00, I need to develope
a query to extract the dollar amounts or cost

I have a query where I have counted the number of records which have appeard
on a report, i.e, 490 records have been on the report 2 days, 34 records on
the report 3 days, etc. How can I sum the count of records so that I have
number of records which have been on the report ...

How can I transform this 206,5 into 206:30h
Thanks.
Marco

I have a reservation db and have just now been able to create a query which
shows each property available on a specific date (thanks to this group).  I
have created a form to input the target date.  This form runs the query and I
have attached a subdata sheet that shows for each ...

Hi. I'm having some problems in converting decimal values into hours.
Sometimes my decimal values are less then 1, that means that the hours are
less then 24h but sometimes my values are 2.5 that means that is two days and
half.

I can count records down in a group on a report. Is there a way to cont and
store in a query to start and renumber from one. I want to get a list of the
top three records in each group I am sorting by.

Having read millions of time not to store results of calculated fields in
tables, I have the following in a field on a form that calculates a date 6
months in the future [target date] from an field [actual date]
=IIf([Actual Date] Is Not Null,DateSerial(Year([Actual Date]) ...

I am using the upsizing tool to slq 2005 from access 2003.  I have three
tables which use 100's of queries.  Some if the primary keys to the three
tables may be the same.  For example I have a storedata table,  a fabric
table and a section table.  In the storedata table the ...

I am trying to combine or total my 3 price per ounce columns by each item.
thenI need a grand total of what the price is per item. Here is my query.
Please help.
Thank you

I have a database that I have been trying to convert into a correct
and recognizable time format. The old db kept time in numeric form
01...2400. The problem is when I try to import this into the new
database using CDate() it gives and error for each 2400 hour. I

I have a database that tracks all active programs and their funding status,
which is suppose to be reported every two weeks.
I have a query that is dependent upon a report date selection in Combo0
which works perfectly but now I need the query to pull those reports that not