I used the following as a query expression to convert unix timestamp.
  DateAdd("s",UnixDate,#1/1/1970#)
This got it done but I am now wanting to go one step further and be able to
have the date in one column and the time in another for additional queries

I have a form with a list on it.  The list is being populated by a table.  I
would like it so that when I click a command button, whichever option was
selected on the list get copied (or moved) to a new table titled "Input".  I
thought about using an append query, but don't know ...

I am trying to figure out how to restrict a query to only pull records with
ONE date. I work for a church, and every Monday, we run several reports on
visitors. We send letters to first-time visitors only. In our database, each
visit is listed. How can I setup a query to only ...

I'm struggling with a query and could do with some help:
I have a table that looks like this:
Rank    EmployeeID    Date      WorkDuty
CC       1000             14/4/07  FLY

I have changed the date format on access to dd/mm/yyyy for mail merge to
word.  However, I am now unable to sort ascend the full date; the sort ascend
is only picking up the dd.
Has anyone an idea of how to overcome this problem?

When using SQL Server I add SELECT @@IDENTITY at the end of the insert
query, what can I do in Access
Thank you,
Samuel

Hi there, below is my query that I get from a tablle:
Row 1                   AZX
Row 2
Row 3

Scenario: AM working on creating an excel report.Where i need to add a
cross tab.When i  export this report to excel format...all the
fields(present in the cross tab) occupy different cells in the excel
sheet.

I need to write a query to compare two name fields and return the "not ok"
from these examples...
J and J ... ok
J and JOHN ... ok

I need to delete a record on a datasheet subform. In order to display
correctly, the underlying query connects 4 tables. How can I delete a record
from one table? The other three tables can be read-only.
Thanks

how can i delete all records in a table where the description starts with a
specific letter?

I have a macro that executes several append and update queries in sequence.
I'd like to avoid the return message (number of records that will be modified
and so on) and then the manual confirmation of each query.
Is it possible?

I've been trying to figure this out for days as a somewhat of a novice in
Access.  I am trying to count the # of issues that a trader (or occ_acro) has
PnL > 0.  I can return the total number of issues that have PnL > 0 for the
whole database with this expression "Winners: ...

I have a table with data like so:
AniName       EnriName    AssignID
beagle            toy                1
beagle            toy                 2

I would like to build a query that would count all the "yes" and "no" answers
from 16 questions that are on the form and then calculate the totals for the
current record only and display those answers in a text box on the form. Each
of the 16 questions has a combox with the ...