Desparately seeking coding help

M

Meegie

How do I turn this generally logical statement into SQL
code that can serve as the record source for a subform
control?

IF: (All records WHERE Logsubform![Dtshtnmbr] =
Current record's Logsubform![Dtshtnmbr]) = 1

THEN: Logsubform![Start Time]=Logsubform.Logentry![Begin
Time]


IF: (All records WHERE Logsubform![Dtshtnmbr] =
Current record's Logsubform![Dtshtnmbr]) > 1

THEN: Logsubform![Start Time]=(Logsubform![Finish Time]
WHERE Logsubform![Actvtynmbr] = Current record's
Logsubform![Actvtynmbr-1])
 

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

Desparately seeking coding help 1
Multiple data sources for subform control 2
Need help modifying code 0
Lookup current record with ComboBox, any changes create new record 3
subform based on external SQL won't requery 1
keep subform synchronized with main form in Microsoft Access 2003 1
Help With Report Coding 4
Using SQL Query Code in Form Module to Return Record Count 2

Top