Search results

I am grouping because without "Total" the query returns 5200 repeating values rather than just the dozen or so tests specific to the product I want to append. Looking at it further I don't need to join tables. Now I have INSERT INTO tblCOATestResults ( TestName ) SELECT...

I have the table that have the tests associated with material. The SQL for my code is INSERT INTO tblCOATestResults ( TestName ) SELECT tblCOASpecifications.TestName FROM tblCOASpecifications, tblCOALots INNER JOIN tblCOATestResults ON tblCOALots.COALotNumber = tblCOATestResults.COALotNumber...

I am developing a Certificate of Analysis (COA) database that will contain the test results of all incoming raw materials we use. Each raw material always has a certain number of tests in each of their respective COAs. I have a table of all the raw materials we use and their tests. I want the...

When I try to drop in a continuous subform into the footer section of a continuous form I get "You cannot do this"

But can I nest continuous forms within each other?

Hello, I am attempting to make a product formulation database for my company. The current formulations are stored in word docs in the format attached. I am attempting to make a clean and user friendly entry form to enter in the product formulation data. Attached is what I have so far. You can...

No. The aggregation is being done at the report level.

Hello, I have gotten to the format attached. It is almost what I want. How do I get the raw material options to go horizontally across the page? Thank you!

Is there a specific report format I'd need? I would need to sub reports? Potentially a sub report nestled in a sub report?

Hello, The formulations for my company's products are contained in individual word documents. I want to enter this data into an Access DB and recreate the format of the formulation sheet as much as possible. Each product has multiple raw material ingredients that each can have multiple...

No I defined it as the control source. I defined the default value of the source controls as a numerical zero. Do I have to specify the control recalculate on a certain event. the value only remains displayed in the calculated control after I enter a record in the subform source control.

There is none. it just has =[QuantityOrder]+[QuantityStock]+[QuantityPartial]+[QuantityDowngrade]+[frmOtherMaterialProduced].[Form]![Othermatsubtotal] as the control

Hello I have a calculated control on a form that is summing other controls and then a subtotal on a subform. This is access 2007 The calculated control does not display the value until I enter a value other then the default in all of the source controls. If I hit the "refresh" button, the...

Hello I have a query that is returning material used for production runs. Originally I wanted the query to only return unique lot numbers for raw material used by setting the count criteria=1. However this isn't working anymore because sometimes the same lot will sometimes be entered multiple...

Hello I am attempting to split an Access 2007 database. My company has two locations. From my location we are remote connecting into the server. While down there they are connecting directly. When I split the database, people in my location can use it fine. When people down there use it, they...

Hello I have a material usage table that tracks material going into products Oftentimes the same material will be used and multiple records will contain that material. I want my query to return only records with unique material used. I'm clicking the "Unique Values" and "Unique Records"...

exactly what i was looking for thank you

Hello I have a table of raw materials that have two fields, their stock code and longer description. I have another table that is tracking the usage of these materials. I want both the stock code and longer description to be recorded in the usage table. I want the "Description" field in the...

Is it possible for a report's displayed decimal places to be conditional. I have field that has a lab test's name a field that displays the result of the test. For some tests I only want 2 decimal places, for others I want 4. Is this possible within the same field?

Ahh, but this will delete the ENTIRE record, correct? I want to leave the record, but delete only the fields with numerical data. Sorry for not being more clear