Search results

  1. S

    Make table query and then using export specs to export the table to text file.

    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...
  2. S

    Mark fields in a report with an * based on certain criteria.

    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...
  3. S

    Error on Query: Operation must use updatable query?

    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...
  4. S

    The select statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation in incorrect?

    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...
  5. S

    Count distinct records on a report

    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...
  6. S

    Dlookup In Query

    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%]...
  7. S

    ROUND Function in Query

    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...
  8. S

    Query to poplulate 3rd field on the fly based on 2 others.

    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...
  9. S

    Help returning query row fields as columns

    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...
  10. S

    Question on calulation in a query

    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...
  11. S

    Combining multiple fields to populate a combo box with different formats

    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...
Top Bottom