Good Morning,
I am looking to write the results of a query to a text file (first creating the text file) I have never done this before and am very confused with some of the stuff I'm finding online.
Can anyone help me with the basic format of this?
Thank you in advance
Hello, I have a make table query that formats data to a table so I can export it to a text file. Currently I am formatting [Field1] like this:
Format([Field1]*10,"00000000") outputs: -00030000. I need this field to only be 8 characters long including the negative(-) sign. Is there a correct way...
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!
Example...
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!
UPDATE CheckStubInfo...
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...
Hello!
I have created a report that contains employee records. An employee can show up twice on the report if they have regular and overtime.
Example:
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...
Good Afternoon,
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:
SCCAmt: Sum(IIf(SCCPremium([SCC],[Bacteria])>0,SCCPremium([SCC],[Bacteria])*[sumOfLbs]*0.01))
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
1.0
1.1
21.0
100.10
empName consists of...