Search results

i am trying to create a statement for my customers which basically will tally what each owes and how much they have paid. i have an invoice and invoice payments table which has been linked via invoice.id and invoiceid the invoice is also linked to the invoice_details table also via invoice.id...

hi im trying to append some records for the day when the date is selected. i have a main form tied to the sdate table and a tab that links form called farm using sdate_id. the sdate is an unbound field that is populated to the current date when the form is loaded. The after update of this...

thanks for taking the time for that long answer. i think it will take me longer to just go through it then you spent on typing it :p

hi. Suppose I have two tables Batch, Farm Basically I want to create an append query so that for the day selected in a form tied to the farm table, I would be able to create multiple records based on the number of records in the batch table with no duplicates. for instance. batch table has...

alright. i hope I can explain it correctly. Relevant tables Farm Batch Sdate Shed Farm table holds farm_id - primary key sdate_id (references sdate table that has sdate being a date of entry. this is in a table as it is referenced by other tables as well) batch_id (references batch_id primary...

I am creating an access database for recording calls and follow ups for a company relevant tables mst_customers card_call ID from customers and customer_id from card_call have a one to many with all records of card_call although its more elaborate than this, lets get down to the problem i...