Search results

sorry for the incompetence Im not sure I'm following correctly. I have dates, etc. But to calculate the invoice amounts, I have to GROUP BY (hospitals) in my SUM query. The doesn't allow me to include non-aggregated fields (in other words, patient name, date etc). Therefore on my invoice form...

Greetings, I have a form that is used to invoice clients. The invoice amounts come from a SUM query because one hospital often submits more than one sample, but do not want to be billed indiv. for each sample. I do need to list all records they are being billed for. (A sort of itemization of the...

sorry, I need to combine RECORDS so that my invoice will list all tests that a hospital is being billed for that particular month. Need it to do exactly what SUM does, but combining text instead of numeric.

I have a SUM query that combines invoice amounts so that clients only get one bill for the month. I can't seem to figure out how to also combine text fields so that I can include an itemization on the invoice. Any ideas? Greatly appreciated, mfpoore

got it, thanks

I need to add a autonumber field to a table from which I built a form. The problem is I have assigned numbers and it must start from 1000000 and number up from there instead of starting with one. Any help greatly appreciated! mfpoore

SOrry about that. Here's the deal. I send out results and invoices for work done from a form. (I dont use a report because forms give me the freedom to filter for hospital ID, etc, and send more than one page at a time, give someone a test at no charge, etc). For the invoices, copies have to...

I think I need to ask this differently. Can I create a form (or report or anything) that has consecutive pages with exact info except for a label or something at the bottom which will be "General Accounting copy", "Clienty copy", etc? The idea is for each record to have several (5 ideally)...

thanks SpacePro. much appreciated

I currently use a form to fax out reports for bloodwork done on patients. I know a report may be more likely usually for this, however sometimes I filter for certain hospital ID's to fax them all at once, etc. Currently I have to go through this process: File > Print (choose fax program for...

re: I like to be able to actually change the prices because the total price is broken into several components going to different account numbers. However, I could work around that, but a report seems to still have a 22 inch restriction. thanks, mfpoore

I have created an invoice form to print out bills, but I need five copies, all of which have a diferent text box at the bottom, "General Accounting", "Client Copy", etc. My first plan was to repeat the data over five times with startegically placed page breaks, however I can only get it up to...