J
JWPosey
I run a query every day against our company database to pull in specific
information. I then store this information locally in my Access db. To save
on space, once I'm done reviewing a record, I delete some of the fields to
keep the db space low.
My problem is that in the future I may have to retrieve these fields. I
keep the ticket number in the Access db the same as our company database
(they both have the exact same format). I create a form so that tickets can
be inputted and then try to retrieve them from the company db, but it doesn't
work if I try to retrieve multiple ticket numbers. In the form I put an "OR"
between the tickets so that it is included in the query. Here is what my
query SQL looks like:
SELECT
.[Trouble_Ticket_#]
FROM
WHERE (((
.[Trouble_Ticket_#])=[Forms]![Retrieve Reviewed Records
Form]![Tickets]));
information. I then store this information locally in my Access db. To save
on space, once I'm done reviewing a record, I delete some of the fields to
keep the db space low.
My problem is that in the future I may have to retrieve these fields. I
keep the ticket number in the Access db the same as our company database
(they both have the exact same format). I create a form so that tickets can
be inputted and then try to retrieve them from the company db, but it doesn't
work if I try to retrieve multiple ticket numbers. In the form I put an "OR"
between the tickets so that it is included in the query. Here is what my
query SQL looks like:
SELECT
FROM
WHERE (((
Form]![Tickets]));