I have 2 tables the first called users has the fields:
UserID, UserName, Comments
The 2nd table called SecurityLogins has the fields:
SecurityID, SecUserID, SecEffDate, SecUserLogon, SecUserPassword

I have a table whose records have four fields.  One is an id number and the
other three fields contain a unique number assigned to that id.  I want to
combine all of these assigned numbers into one field so i can make a list of
the assigned numbers.  How do I do this?  

I was interviewed for a job today and they asked a question that baffled me.
If you were given a list of 100 names, how would you seperate them into 10
distinct groups?
I asked, "Grouped by what?"

i need to pull data from table, where the data needs to be limited to be
inbetween a specific range of dates and times like, say ill need to see only
those records that were entered sometime between 11/1/2005 4:00Pm to
11/2/2005 3:00am. (I work overnights, so i start on monday ...

Newbie,,sorry... I have a query that runs a list of al tasks outstanding by
customer, from within that dataview i would like to be able to open the
customer form for editing is this possible.
thanks

I wish to number records, in natural order from 1 to n
There is no numerical or date comparison or sort that will allow be to rank
using the techniques listed (that rely on there being count() records in my
query that are logically lower than the current record.

i have several queries which have a date range as a filter (between dates) eg
i put in on a form start date: 21 nov 05 and end date 20 nov 06 and the query
filters out all other records.
what im having to do is each year, alter the dates to the current year. eg

I can locate the record I'm looking
for with
Set rst = db.OpenRecordset("tblData;")
rst.FindFirst left("Code", 13) = Me.cmbLookup

I have a query with a sub query and need to perform a count on the sub query,
i.e. for the record in query how many records is the sub query bringing.
How do I do this?
Can I use the Expresion Builder or the SQL window?

My query uses a function (fclinetID) in the clientID criteria.  Sometimes I
want to run this query for all clientID records (not null records).  Is
there a way to use someting like the following code.
IIf(IsNull(fclientid()),"ALL RECORDS" ,fclientid())

I'm using office 2003 and have tried to reset the autonumber in a table by
appending a new start number into the table as directed in help, but it is
not working.  Specifically, I have created a new table with a field named the
same as the autonumber field in the table I wish to ...

Office 2003
I want to create a report similar to an aged debt report.  I want the
columns to be
0-14 days

Hi All, i have two concerns here:
1) Recovered Design Master, unreplicated Tables and Queries. How do i
unreplicate Forms, Reports, Makros, and Modules?
2) To unreplicate Tables and Queries it took me a while. Is there any way to

I'm querying a table with subscription information that contains customerID
and end date.  I want to query for all subscriptions ending in December, so
I'm entering criteria of "between 12/1/2005 and 12/31/2005.  That works fine,
but can I enter the criteria to query for all ...

Dear Michel,
I would like to thank you for your answer.
Datestamp <=Date()-90
Date(): isn't it the current date less 90, will it show me a bill dating