Hello, I have a make table query that I then created a specification to export it to a text file. Some of the fields contain decimal places, but the business I am creating the text file for would like to elimanate all decimals and right align the numeric values. Thank you in advance!
Hello, I understand I can highlight a field with conditional formatting but I am looking to asterisk fields based on criteria of the field.
Ex. I have a text box txtNumber
If txtNumber <> between 3 and 5, then I would like to display the Number with an * next to it, otherwise just the number...
I have the following query that I am trying to get a sum of deductions for a PayPeriod and update the CheckStub record with the totals. I am receiving the error: "Operation must use udatable query" when executing the following query. Any help would be much appreciated!
Good Day to all and Thank you in Advance,
I am stumped on why I am receiving the following error message.
The select statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation in incorrect?
My code is as follows:
stSQL = "SELECT...
I have created a report that contains employee records. An employee can show up twice on the report if they have regular and overtime.
Emp No Hours Type
100 40 Reg
100 2 OT
102 40 Reg
At the bottom of the...
I'm trying to execute this query to return a value from another table(GradeAQualityAdjustment).
SELECT CheckStubInfo.PatronNo, CheckStubInfo.[BF%], CheckStubInfo.SCC, CheckStubInfo.Bacteria, CheckStubInfo.[Protein%]...
Hello, I am receiving the error from my Query below: "Wrong number of arguments used with function in query expression 'Sum(Round([BFPercent]*[Weight]),2) AS BFPounds'. If I remove the ,2 from it the query executes just fine.
I thought the ROUND function allows for that additional parameter to...
I have a query that is outputting 2 fields, but I'm wanting to populate the 3rd [Expr1] based on the [PatronNo] and [Main].
If [PatronNo] is empty I was to display [Main] in [Expr1] or if [PatronNo] is equal to [Main] I want to display [Main] in [Expr1], otherwise display...
Below are the results of my query calculating a Main Patron weight and a Sub Patron Weight (two totally different calculations). What I'm trying to attempt is to show both the MainPatron field and the SplitPatron field in the same column named "Patron". I would also like to do the same with...
Good Morning All,
I'm trying to figure out how someone calculated a field in a query I am working with and I am confused. Here is the calculation:
I'm especially not understanding this part...
Hello and thank you all in advance for your help.
I'm currently adding two fields together in a query to populate a combo box that then in return passes those values to a report.
My first field: empID
My second field: empName
empID consists of
empName consists of...