I have a table that comes from a SAP report.
the fields are
ID PrimaryKey
Work Order
Description
Location
WorkType
Status
LFC_AssetDept
Target Start
TArget Start Hour
ScheduledStartD ate
Actual FinishDAte
ActualFinisgHou r
ActualFinish
ActualLaborHour s
Lfc_PostAudit
LFCAuditSupervi sor
EstamatedLAborH ours
AssignedOwnerGr oup...
jeannier1975
Last Activity: Jun 13 '19, 08:09 PM
Joined: May 16 '18
Location:
-
Count records with multi criteria using VBA
1 High Priority 0 Views Last Modified: 2019-02-13 Edit Question
I have many queries were simply to come up with a number that is a count of records with a specific criteria, to be used later in a calculation. Because those criteria are so lengthy, and change with each variation of the dataI am collecting, I’m not sure if an IIF structure would return the results you want. Crosstab queries can get quirky when fields are not available... -
I need to count the work orders for each department that is comp ,fcomp with actual labor hours that the work order was complete not in 00:00 and between the the start date and end date.Leave a comment:
-
Because i took the cheese department and calculated the cheese department which is 159/184 and i 86.41 but when i run the queries with all the drpartments i get 95.2Leave a comment:
-
The numbers are not coming out is there a better way to do what im trying if i run the department queries seperate they work but when i try to do it with one query the numbers dont match.Leave a comment:
-
when i do that it doesnt get the right results for department presentagesLeave a comment:
-
joining queries together
i have two queries I want to join so i can get the percentages from each department of completed work orders but not sure how to go about it. I know i want a join and a crosstab query so i can display the results in a report.
The first query calculates the numerator,
...Code:SELECT Count(MaximoReport.WorkOrder) AS CountOfWorkOrder, MaximoReport.[Assigned Owner Group] FROM MaximoReport WHERE (((MaximoReport.WorkType) -
i do appologize i just dont know how to explain what the issue is because i cant troubleshoot the materLeave a comment:
-
Answers i have the data in the table deleted.
The calculations are not returning the correct numbers in the database after i run the parameterf with the parameter dates.
Yes i have the data types set on my database that why i attached the upload link of my database.Leave a comment:
-
Queries
Question: I have looked everywhere and even paid someone to look at the issue I am having. 1. I have a routine that deletes the table data and loads new datatable that is download from an SAP application. the issue i am having is that when i run the old data in the queries i get the correct calculations and percentages. But when i input or import new data after the old data has been deleted my queries are not calculating the data percentages correctly....Last edited by twinnyfo; Jan 30 '19, 06:27 PM. Reason: Please do not post links for database downloads. -
VBA Help
I have a database that a user will upload several excel sheets the database works except when i add new dates to the database.
When I created the code to import the Excel data, we added a column called ‘WeekImport’. I think this field might be able to be used as criteria in queries to only pull the data from a given import. The only tricky part would be to correlate the selected date range in the form with the proper recordset. I think... -
jeannier1975 started a topic prompt the user what week is this import, take that number add it to week field on ain Accessprompt the user what week is this import, take that number add it to week field on a
I need to create a vba function that asked the user what week they would like to run a report. I import weekly reports in a database and when a user imports the data I need to be able for the user to put week 1 or 2 ect. when prompt does anyone know how I can do that -
unbound main form with multi subforms with parameter query
So i have an unbound main form on the main form it has two text boxes for date date to and date from. I have two comand buttons Run And clear.
I have 8n subforms on the main form that load the percentages of the different departments base on those dates entered by the user. It works without the text boxes but when i put the the dates in the text boxes it doesn't work. In all the queries i put in
>=DateAdd("h" ,-11.8,Forms![DashF]![DateFrom])... -
cheese field departmentb fields for pM COMPLIANCE the calculation for each of the departments thefist query
...Code:SELECT Count(MaximoReport.WorkOrder) AS [CountOfWork Order] FROM MaximoReport WHERE (((MaximoReport.WorkType)="PMINS" Or (MaximoReport.WorkType)="PMOR" Or (MaximoReport.WorkType)="PMPDM" Or (MaximoReport.WorkType)="PMREG"Leave a comment:
-
70 queries i would have to send youLeave a comment:
-
because the data i need display come from several queries from the table.Leave a comment:
-
i van send you a copy of the db im not sure how i can get all the forms to layout the way i want them to
You can download the database from address: http://s000.tinyupload.com/?file_id=...95908091720321Leave a comment:
-
I think i'm going to use subforms for each query and attach it to the main form . since i'm really having a issues with getting the query's data inside the unbound text boxes on the form that is unbound.Leave a comment:
-
Yes the values come from several different queries.Leave a comment:
-
unbound form
I have an unbound form that I need to insert several calculated fields data into a unbound text boxes. I have all the calculated queries all done I just need to insert the values into the text boxes. I thought of using Dllookup but I get an error ?name when I put the Dlookup on there controls property of the unbound text box.
Please help.
[imgnothumb]https://bytes.com/attachments/attachment/9810d1543875978/form-1.jpg[/imgnothumb]...
No activity results to display
Leave a comment: