Trying to build a data input form that appends new entries to data

D

Dick Starr

I have a bartender tip tracking app that needs an input data form attached to
an append query.
User sees only new data for current shift.
I have 2 tables. Employee and tips.
I will use a form with tips subform.
I will track by employeeID field between the 2 form sections.
I want the append query to load the current transaction gross, shortages,
net tips.
I have been playing with append queries and have one (no form) that copies
all table tecords (tblTips) to the append records list.
I think I need to tell the query to add new records that the user is
modifying.
Any wisdom would be a few steps ahead of me!

R Starr
 

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

Adding data to MS Access from csv file 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
query field names changing to expr#: 8
create append query resulting in multiple new records 4
Append query from form input - Access 2000 1
combo box 1
Copy previous record into form field 0
How to Retrieve Data From Another Access Dataase Without Linking to It? 3

Top