Insert row in continous form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help me out here.Im doing a greyhoundracing database and on the
form it currently displays like this:

Greyhound Name
DateRun Daysdiff(between runs) Finish Time
07/04/2005 90 1st
65secs
07/01/2005 4 2nd
60secs
03/01/2005 0 2nd
62secs

But would like to insert a line or another column so it looks like this:

Greyhound Name: Brett Lee
DateRun Daysdiff(between runs) Finish Time
07/04/2005 90 1st
65secs
---------Spell 90days-------------------------------------------------------
07/01/2005 4 2nd
60secs
03/01/2005 0 2nd
62secs

any help would be greatly appreciated.tks
 
Thanks, however if i insert a line it comes up for every field row where i
only want it to appear if the greyhound hasnt run for 90 days or more.if it
runs withing 7days then a line wouldnt appear.
 
Ah...you didn't mention that before....

You can still have that by having that line on the form in a single text
field, and setting the property of visible to "no" if the condition is not
met for that record. You need to have another calculated field where the
value of 90 or more is calculated. Have you done something like this before?
 
thanks destin, thats sounds like the right idea.I will try that.Only
relatively new at databses and have actaully posted another query on how to
calc a date difference from a field in a table.One step at a time i guess.Tks
 
Mark, feel free to contact me directly for fast results. Just have the
question written out as much as possible - I'd be glad to assist on your
other question.

Destin Richter
(e-mail address removed)
 
Thanks the offer.
With the date difference I need to work out days between each run the
greyhound has.I have the following fields Daterun, Grayhoundname,
Finishpoistion....etc
So i need to somehow use datediff to calculate the difference in days
between each entry in the table.Trouble is i dont know how to
datediff("dd",[daterun]-(**theprevious daterun**)[daterun]) and get it to
work!

Greyhound Name
DateRun Daysdiff(between runs) Finish Time
07/04/2005 90 1st 65secs
07/01/2005 4 2nd 60secs
03/01/2005 0 2nd 62secs
 
Destin Richter said:
Mark, feel free to contact me directly for fast results. Just have the
question written out as much as possible - I'd be glad to assist on your
other question.
Click to expand...

That defeats the purpose of newsgroups where both the question and resulting
answers are available to everyone. It also reduces the chances of getting
the best answer since only 1 person can respond instead of everyone.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top