Anybody know how to include a column which just increments by 1 for each row
that the query generates?
Thanks!

I have a table where the date field is text. I need to make a query to find
dates Between 01/01/2006 and 06/30/2006.
Using the criteria BETWEEN "01/01/2006" AND "06/30/2006" will bring up every
record between 01/ and 06/ but it will not limit the year to 2006.

I have built a master form which queries contractor names.  This form is link
to two subforms which are pulled from two tables which are related:  
1)  Subform has all of the contact info for the companies
2)  Subform two has what they specialize in.

I have a table named "Log" that stores: RecordID (AutoNumber),
LogInTime (Date), LogOutTime (Date). I have a form named "LogIn" that I
run (with an AutoExec macro) every time the application starts. It
collects the LogInTime and stays open (invisible) so that it records

Hi experts,
I have a pop-up msg box that ask the user to click OK to proceed and
Cancel to stop the macro from running further. It is noted in my macro
condition under Msgbox action. Code:

I need to create a query (and then a report ) that shows the data from rows
into columns; all data is from one table.
The fields of the table are:
  SerialNumber

I have a User requriement to dynamically enter a line number in report
definitions and existing line numbers > new line number get incremented so
that all sections order correctly. (Cobol bleah!)
I am using a continuous subform to show report sections.

I have a query that I am trying to run starting with the following dates... I
need to pull off the records between certain dates.  When I log a call in our
Help Desk database, this is how it stores the date and time the call was
opened.

How can I create a field in a query which is the difference between the
current record and the previous one? For example:
Field1     Field2
2            2

I get the result in Access to round fine, until it is output to excel.
For example:  actual result in access is .5, queried as 1, but when I output
it to excel, it shows .5, not the desired 1.
I used Round([Expression],0) in access to get the 1 result in the query.  So

I have a Primary Table with contact data of journalists and
publications.  Each consultant in the office has his or her own table
with only selected (not all) records from the Primary Table.  (Some of
them may use the same records).  I would like to have the records

I created a form Test (temp name) with 2 comboBox :
Month: SELECT DISTINCT Month([WeddingDate]) AS [Month] FROM orderInfo;
Year: SELECT DISTINCT Year([WeddingDate]) AS [Year] FROM orderInfo;
then I created a query, in the criteria of the field WeddingDate I put :

I've got a database to which I need to make modifications based on client
changes.  One of the functions of the database is to do some math on values
and deliver the results in a report.  The reported values are hours
multiplied by $/hour.  The requested changes will, from time ...

I need to calculate the day of the week for a date/time field in a query.
For example, DOW([Start Date]) would return "Wednesday" if the value for
that record were 8/9/06 00:00.

I have what seems a very simple issue but has been a major problem for
me to resolve...
I have 2 tables; 1 (widgets) describes my items in detail and includes
a unique primary identifier for each type of widget (not an