I've been trying to add records to a query. When I close the prog.

[Guest]

I have several databases I've started working with. I have to continually
add new records to them. I open a query and attempt to add records, save it
and then close down. When I reopen the query, the new information is gone.
What am I doing wrong?

 

[Guest]

Have you checked the file the query is attached to? Is the information
there? if so, you may have a filter on the query that doesn't allow the
record to show. check the query in design view and check the criteria row for
each field.

Theresa

 

[tina]

you don't add records to queries, you add them to tables. a query is
actually an instruction (a SQL statement) telling Access that you want to
see certain fields of records - in one or more tables - that meet criteria
defined in the instruction. when you "open" a query, you are seeing a subset
of the records in the table(s). when you add/change/delete records in that
datasheet window, you're adding them to the table(s).

if your query includes criteria, you might be adding records in the
datasheet view that don't meet the criteria. so the next time you open the
query, the added record(s) would not be included. have you looked in the
table(s) to see if your added records are present?

btw, is there a particular reason you are adding records to a table via a
query's datasheet? normally, you add records to tables via forms.

hth