Last record

[Haggr via AccessMonster.com]

I would like to find the that record of a job "[jobNumber] using [FileNumber]
a "Auto Number" field and all the other info, or atleast the info I need,
with that record. Ex. Sometime I need the last record for a "job" where a
field

 is "2"  or a the last record for a "job" where the field [Date]
=>Date. All of these fields are in the same table.  I can do it in Query grid
design, but it take a few sub queries,sometime alot, to do it.  I know you
guys you probably write a SQL. Thanks

 

[Smartin]

I would like to find the that record of a job "[jobNumber] using [FileNumber]
a "Auto Number" field and all the other info, or atleast the info I need,
with that record. Ex. Sometime I need the last record for a "job" where a
field

 is "2"  or a the last record for a "job" where the field [Date]
=>Date. All of these fields are in the same table.  I can do it in Query grid
design, but it take a few sub queries,sometime alot, to do it.  I know you
guys you probably write a SQL. Thanks
[/QUOTE]

Have you tried the TOP predicate?

 

[Haggr via AccessMonster.com]

meant to say "last record"

I would like to find the that record of a job "[jobNumber] using [FileNumber]
a "Auto Number" field and all the other info, or atleast the info I need,
with that record. Ex. Sometime I need the last record for a "job" where a
field

 is "2"  or a the last record for a "job" where the field [Date]
=>Date. All of these fields are in the same table.  I can do it in Query grid
design, but it take a few sub queries,sometime alot, to do it.  I know you
guys you probably write a SQL. Thanks[/QUOTE]

 

[Haggr via AccessMonster.com]

I need to find the "Last" record of a job "[JobNumber] using [FileNumber],
a "Auto Number" field, ("I think?") and all the other info, in that record,
at that time.

Ex. Sometime I need the last record for a "job" [JobNumber] where a
field

 is "2",
Or    the last record for a "job" [JobNumber] where the field [Date]
=>Date()

 

[Guest]

Show us a query that works close to what you want now.

Also remember that "last" has little meaning UNLESS you have something to
sort on in the table.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I need to find the "Last" record of a job "[JobNumber] using [FileNumber],
a "Auto Number" field, ("I think?") and all the other info, in that record,
at that time.

Ex. Sometime I need the last record for a "job" [JobNumber] where a
field

 is "2",
Or    the last record for a "job" [JobNumber] where the field [Date]
=>Date()
.
All of these fields are in the same table.
I can do this in Query grid
design, but it take a few sub queries,sometime alot, to do it. Hoping there
is a better way.

[QUOTE]
I would like to find the that record of a job "[jobNumber] using [FileNumber]
a "Auto Number" field and all the other info, or atleast the info I need,
with that record. Ex. Sometime I need the last record for a "job" where a
field [Code] is "2"  or a the last record for a "job" where the field [Date]
=>Date. All of these fields are in the same table.  I can do it in Query grid
design, but it take a few sub queries,sometime alot, to do it.  I know you
guys you probably write a SQL. Thanks[/QUOTE]
[/QUOTE]