After over 16 Hours buzzing with a problem I give up. I need some
expert here (I think). Here it goes...
I need to run a query from a subform (it took me very long time to find
that this is the buzz...). The condition of this query is sited on a

I'm an experienced MSA programmer since version 2... But now I need to
learn how someone else setup a certain database. The names of tables
and queries are terrible and not recognisable as either tables or
queries by their name.

whats the best strategy to make search text box. I want, while typing in a
search text box, a list to display only results that have substring that is
equal to string in a search text box.
thanx

I'm at an intermediate level with access.
I have a pretty large database, with queries containing two tables. But when
I look at the query, the navigation bar does not allow me to create a new
record.

I have 2 tables; one field in Parts is a foreign key into Locations.
select Parts.Name, Parts.Description, Locations.Description
from Parts left join Locations on Parts.LocationID =
Locations.LocationID;

I have a query that i need to select records which fall between a 7 day frame.
I know how to have the criteria prompt the user to enter a start and end
date ( >=[enter start date] and <= [enter end date]) however I'd like the
user to be able to pick a start date based on another ...

I have created a parrameter query which i have to type in a keyword to get
results based on the word, i run the query to a form.....my question is
this....is it possible to create a command button that will rerun this query,
what i have done for the moment is create a command ...

Having a Crosstab query where columns heading are dates... how can I make it
only display last 5 days columns? Take into consideration that I'm not
including weekends.. any help will be really appreciated

Hello and thanks for the help.
I need the syntax that says, select the records where the 5th letter is not
S.  The values look like this 1234A123.  I need the query to select something
like this 1007E001, but not a value of 1008S002.

Hey everyone! I have an issue I can't seem to get sorted out on my own here
that I've been trying to find an answer to for a week now.  Here's what I've
got:
I have the following tables:

I know that this will probably be a simple question for all of you experts
but I've been pulling my hair out while trying to get this search to work!!
Going around in circles is driving me nuts!!!
This is what I want to be able to do if you follow this link

To give you the background, I have a field for every month from Jan 04
to Present with a dollar amount associated with it.
I want to be able to pull up a specific persons record and show the
Total of the row

I done some searching on rounding up, but none seem to be what I am looking
for.
Here’s what I need to do.
If myTotal field is greater > then 40, divided / by 30 then round up to

Hi, Please help...
I am struggling with something really simple today, I want to write in my
query if Names appear in the data not to show them.
eg

I have the following query:
SELECT loanActivities.officerNumber, Sum(loanActivities.Service_Charge)
FROM loanActivities
WHERE (((loanActivities.Date_of_Loan) Between #1/1/2006# And #3/31/2006#))