Search results

Thank you! I will give it a try and let you know how it goes! :D

SURELY the old saying "If there is a will, there is a way" will still hold true for this one! I have a database that keeps track of lab records. If I have a set of ten labs on a particular invoice, such as these: .Lab Number.|.TestWanted.|.Description..|.Price...

Ok... how about this plan: The only consideration (that I can think of) that a set up like this WOULD NOT account for, is the fact that, if there is a company name, more than likely there will not be a contact name (FName and LName) given... tblCustomers CustID FName LName Address ZIP Phone1...

There will be TONS of records (counted in 100ths of pounds). The big concern for me is wasted space. I will be working with customers and invoices, numbered in the 10s of thousands, as well as laboratory data in the 100s of thousands of records. For instance, it is WAY easier to make one...

Which would be the larger evil: (A) Having lots of blank cells within 1 table, or (B) having multiple small tables with no blank spaces, but having to have complex queries accompanying them to be able to combine the data to resemble the 1 table in (A)? Thoughts?

It works great! :D I ended up using it to join 5 queries together... SELECT * FROM [TESTSoilLabs] UNION ALL SELECT * FROM [TESTWaterLabs]; UNION ALL SELECT * FROM [TESTForageLabs]; UNION ALL SELECT *FROM [TESTBiosolidLabs]; UNION ALL SELECT * FROM [TESTResearchLabs]; You have definitely...

You have made my invoices look PERFECT! Another big THANKS to John from the other side of the world :)!! AggieLJ

Hello All! I have multiple tables containing lab information, invoice information, and customer information. I would like to have a "master list" containing all the data in a compact form. The Table/Fields are like this: Table:______|___Invoices_____| Field:______|___InvoiceID____|...

I will eventually need a report that will look like the example below, so my question is: How would I structure my tables to get the information to be able to be displayed this way? :confused: (A little background: I work with lab numbers with a possibility of having multiple tests required...

I have the same problem, although mine is an invoicing challenge. It just looks unprofessional to have the report footer (which is the invoice's send-in-your-payment stub) end up at the top or middle of the page... I have them in a sub-report, so if there is VBA code or something to align the...