Help Using APPEND Query

D

DanielWalters6

Hi,

I'm looking to create a "LOG" table. This table will contain 4 fields;
1. SessionID - AutoNumber
2. DateTime - Text
3. User - Text
4. AccessLevel - Text

Very simple.

Purpose: I can eventually (6months or more from now) create a report to see
if more staff/users/admin are accessing the system and what times they are
accessing the system, am/pm etc.

I have created a public function which determines and returns the username
I have created a public function which determines and returns a string
identifying their access level. "Student" "Staff" "Admin". - This table will
be for log purposes only.

I need to have an append query which I can run, which will add the following
to a new record in the table:

1. SessionID - AutoNumber - Automatically?
2. DateTime - Result from NOW Function
3. User - Result from my function ie "DAN"
4. AccessLevel - Result from my Access Level.

Any help would be most appreciated.

Thank you in advance

DAN
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking for Information Word (Office 365) editing using VB.Net 1
Append Query To Table 3
Append query key violation 8
Using a combo box as a criteria for a query 1
Append Query w/ 'next number' 0
Append New Record Via A Form? 1
Append Query 3
Access Append Query 2

Top