• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

Marked Finished

I have an excel spread sheet that has a column with a bunch of different invoice numbers. For everyone of these invoices, I need to have the "Finished" box checked off on the access form. Going through and doing it by hand creates problems, is there a way to automate this process. So that any invoice number in the column is automatically marked "finished" check box in the form (or table)?

What would be the easiest way to do this?
0
cansevin
Asked:
cansevin
  • 2
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
import the excel file to a temp table
file >get external data > import

after importing run an update query

update tableX
inner join temp On tablex.Invoicenumber=temp.invoicenumber
set [finished]=true


or if you want just create a link to the excel file then
run an update query similar to above
0
 
cansevinAuthor Commented:
Any chance you can help with with the attached file?

What I need to happen is the any BookingID from Column 1 of the excel sheet, I need to marked the check box "MadeinQuickbooks" in the table "Bookings"
PracticeCMdb.mdb
0
 
cansevinAuthor Commented:
Forgot the excel file
InvoiceSheet1.xlsx
0
 
Rey Obrero (Capricorn1)Commented:
just follow what  i posted at http:#a34939516
* change the name of tables and name of field
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now