I'm new so the answer might be staring me in the face.
My users will be importing a new table weekly to my databse.
That table doesn't have all the fields that my form needs to see.  
It's just going to have three fields firstName, lastName and SSN for each

I am trying to write a query that will give me 90 days from a certian point;
90 Days Out: DateAdd("d",-90,[ETS]), (ets is the date when someone is
leaving), this gives me all the days, but how do I write it so that I only
get days that are 90 days from the date they are leaving.

**Please note: I am a novice at Access.**
I have included a combo box in my table which lists keywords that pertain to
each record in my table.  There are only about 10 keywords.  I would like to
set up a parameter whereby the user is prompted to select one of the keywords

I am running a query to decern the years and months elapsed from one service
to the next.
I can run it to display the year but not month.  Here is my funciton: YRS:
DateDiff("yyyy",[BIRTH_DATE],[CLOSING_DATE]).  How do I incorporate the month?

How do I design a query that will multiply the revenue by different values
when the sales stage is a certain value?
For example:
Sales Stage     Revenue

I would like to set up a query to display all records containing a deadline
after whatever the current date is (i.e. all records w/ deadline after
7/1/05).  Any help is appreciated.

I'm trying to rank the results of a crosstab query.  I've tried using the
information provided from Article ID 208946 but I keep getting an error
message saying the Microsoft Jet database engine does not recognize the field
name.  I have double and triple checked to ensure there ...

I am writing a query based on two tables. My query returns data but it is the
‘ID data or linking data’, just a number.
For example: How do I instruct the query to display TestReportLab
(meaningful text) rather than TestReportLabID (just a number)

Can someone tell me how to use this function.  I receive key violations in my
append query and I want to create a table of the records that are not
appended.
Thanks in Advance!

is it possible to apply a filter to a listbox, based on a value received from
a combobox?   any tips are greatly appreciated

Can anyone advise how I enter criterion 'if field not blank' in a query -
e.g. If MyField not blank "1202=MyField".
Thanks
Dudley

--------------------------------------------------------------------------------
I need help.
I have several Excel formulas that I need to use in Access. I am no
sure just how to do it. What I need to do in Access is find th

I need to create Contact Database.  Fields are :  number, name,
tel_number,email,mobile_number,department.
I need this database department basis.
Could you please tell me  a very good method to create this.  What tables I

I have linked a csv file as a table.  I generated an append query then I
generated a Make-Table query.  I then get a message that says "The existing
table will be deleted before you run the query.  This generates all the
information every time I run the query.  My problem is the ...

Is it possible to open a query directly into Filter by Form view?  
I want to open a query directly into Filter by Form so that the user can
select the right value from the dropdown and see only those records in the
dynaset. (Parameter doesn't work because value in dropdown is a ...