G
Guest
The user needs to pull up records by specific quarters or product types from
a form.
qtr ProdType
2004-01
2004-04
2004-07
a form.
qtr ProdType
2004-01
2004-04
2004-07
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
PC Datasheet
Access is very good but I don't think it has any recordsts you can eat!
G
Guest
Edible recordset! Now there's a solution to world hunger....
M
Marshall Barton
SharonInGa said:The user needs to pull up records by specific quarters or product types from
a form.
qtr ProdType
2004-01
2004-04
2004-07
Aside from jokes about your typos, I don't see enough
information in your post to figure out what you're trying to
do.
R
Rob Oldfield
Perhaps...
set rs=db.BakeRecordSet("select * from ingredients where item<>'spinach'",
dbWithSideSalad)
But seriously.... what's the question? If you're grouping records by
quarter (or whatever) via a group query then the results aren't going to be
editable. You could use a make table version of the query and then base the
form on that but I'm not quite sure if that's what you're asking. Any use?
set rs=db.BakeRecordSet("select * from ingredients where item<>'spinach'",
dbWithSideSalad)
But seriously.... what's the question? If you're grouping records by
quarter (or whatever) via a group query then the results aren't going to be
editable. You could use a make table version of the query and then base the
form on that but I'm not quite sure if that's what you're asking. Any use?
P
PC Datasheet
set rs=db.BakeRecordSet("select * from ingredients where item<>'spinach'"
and where item<>'eggs'"
dbWithSideSalad)
I hate eggs, too!!
and where item<>'eggs'"
dbWithSideSalad)
I hate eggs, too!!
G
Guest
I apologize for the incomplete question. Got interrupted and accidently sent
the incomplete question to the newsgroup. I did repost the full question as
"Recordset Filters" and will attempt to work through Mr. Snell's suggestions.
the incomplete question to the newsgroup. I did repost the full question as
"Recordset Filters" and will attempt to work through Mr. Snell's suggestions.