Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have production table contains 2 fields, called From No. and To No. Since there are a number of pieces of product produced on daily based. eg. I have 100 pieces, every piece needs a unique serial number. If I enter the first serial number into From No. field and last serial number into To No. field.
My question is that: is it possible for access to pull out those serial numbers in a range from those fields and pace them in either query?
Does anyone have a clue
The information in three fields is identical, that is to say, that I created a drop-down list with that information. The users want the ability to list 3 Meeting Reasons, and I don'tthink that Access has the capability to eliminate the options that match when the user selects the first reason, and then the second reason.
Example: Choices for the field are: "Planning," "Production," and "Party."
If I select "Planning" for the first field, I can't force Field 2 to have a drop-down with that choice gone. Field 2 will still have the same four choices.
Therefore, I decided that I would create a Validation Rule. My hope would be that the user could select any option for the first field, but if they selected the same option for the secondfield or the same option for Field 3 that matched 1 or 2, they would get an error (or Validation Rule) message when they tried to save/exit the record.
Example: User selects "Planning" for Field 1, and "Planning" for Field 3. That should invoke an error and an error message.
Here's where I get lost. When I create a new Plan (or another record in the Planning table), I want it to copy any Issues that do not have a Status of Complete to the new Planning record.This way I can keep issues active but still go back and see what was on previous Plans.
SELECT [Print Production Input Table].[Project Name], [Print Production Input Table].[Print File Name], [Print Production Input Table].[Machine Envelope Count] AS [Envelope Count]
FROM [Print Production Input Table]
WHERE [Print Production Input Table].[Print Date] Between Forms![Print Production Input: Envelope Count Report Form]![StartDate] And Forms![Print Production Input: Envelope Count Report Form]![EndDate];
NOW, say in the report that this query is a part of, I want a Project to only be listed once with a calculation of the envelopes from the various Print File Names that are a part of the particular Project Name. Right now, it prints out the Project Name over and over with each Print File Name. I want to condense that
To explain, I have two tables, Production Activity in CY 2012 and Production Activity in $ 2012. Both tables have a field "Date of Activity." In addition to some other fields, ProductionActivity in CY has a field "Actual Production in CY" and Production Activity in $ has a field "Actual Production in $".
Now I had initially created two forms, each dedicated to one table, however my supervisor wants to use only one form to update both fields.
I created an access project using link tables to a SQL development database. I finished the project on the development side and need to connect to production database. I created the SQL user objects on production database, validated that the user can connect directly to database via SQL Enterprise manager. Created ODBC connection on my laptop and tested connection. Modified Global module for the SQL connection for the VB code to point to production database. Open the access project that now points to production database, typed in login credentials to receive user cannot login to database.
What else do I need to modify to point the access project to production database?
IIf(IsNull([CPC_Old].[Project released for planning Actual]) & IsNull([CPC_New].[Project released for planning Actual]),"","N/A") & IIf([CPC_Old].[Projectreleased for planning Actual]=[CPC_New].[Project released for planning Actual],"No","Yes")
The output I'm getting is Yes if they both fields match, No is they are different.this is working.but it appears that if both fields are null then it defaults to Yes.
Each "Well" has many monthly "Production Entry"
Each "Production Entry" can have many "Adjustments"
I am trying to create a report that will resemble the following, but I am unable to get my totals to work:
Production Date, Production Amount
Adjustment Date, Adjusted Amount (negative value to zero entry)
Adjustment Date, Adjusted Amount (positive value for new entry)
[Total of Adjusted Amounts]
[Total of Adjusted Amounts +/- Production Amount]