My main query pulls some student ID fields from a table and uses a few fields
from three queries.  The problem is if the student does not have information
in all three of the queries the student's information is not listed with the
remaining fields blank.  I need the student's ...

I have tried every formula and method I can think of and decide to turn it
over to the experts. I’m trying to get a percent utilization based on a date
range (sent to the query from a form) using Input1 for beginning date and
Input2 for the end date. Below is an example of the ...

I have a table with the following data:
[Upgrade date]   [Ticket Number]   [Agent Opened Date]
2/12/2006               235556                     5/18/2006  
I need to trend the tickets opened weekly for a 30 day period prior to the

In a Mutivalue database, time is stored as a number like "27108"
representing the number of seconds since midnight.I would like to convert
the number into Hrs:min in Access query using a formula. Any help is
appreciated.

Hello, I was wondering if there is a way to select distinct when you
concatenate.  Basically I have a query that pulls EVENTID from tblEvent and
then concatenates NAME and FILENUMBER from the same table.  I would like to
be able to SELECT DISTINCT FILENUMBER in the concatenating ...

Im trying to creat a query that has only grabs the highest trans_code and the
highest Next pay date. Right now when i run the query im getting records that
show all the trans_codes for the Next pay date that is with in my date range.
I have tried doing last but im still getting more ...

I have a huge database of stock market data. It is a list of daily prices.
Hypothetical eg
Code Date Price
ABC 01-Jan-1980 $2.10

hi... i need help with the following. i have the below table
Date            AHTTarget   AHT Budget   ProdBudget    QualityBudget
2006-06-01    140    90    90      90
2006-07-01    136    90    90      90

okay, so why won't this work?
i put the message box in to tell me what the code was writing, and it
is EXACTLY the same as if i hard coded it into the query criteria.
so , query criteria typed straight into query works but doesn't if

I've been tasked with converting an Access 2003 solution to .Net & SQL
Server.  The Access solution has an MDB file that contains the database and
some query definitions out on a file server.  There is also an MDE file that
contains the UI, reports and some more query definitions ...

im designing a database that a user has to enter his personal information in
it, including his country of birth and city of birth i want the user to
select a country from a combo box and after the country is selected only the
list of cities that are in that country would appear, ...

Hi, i'm looking for some help with an appointment system for a local animal
sanctuary and I keep thinking it can be done with a query but I can't seem to
figure it out. My problem is this:
When I have found an animal in the database, I want to be able to add an

I have created an expression #1 [DepositAmount]*1.03-[DepositAmount] to
obtain the average on the deposits.Now i want to create expression #2 which
will use the results of expression #1 to provide another calculation. For
Example:

I have a database with two tables:
tblBookInfo - has a unique number for each book, number of pages per book
and begining and ending page numbers
tblPageNum - has a unique number for each page, related book number for each

I need to make a chart for statistics of machines.
Table:
MachineID: 43
Starttime: dd.mm.yy hh:nn