Recent content by spet

  1. S

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

    Thank you so much theDBguy! Worked like a charm, exactly what I as looking for.
  2. S

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

    I will just multiply my fields by 10 in my make table query. Still not sure how to get a spaces in front of these during the output to text file.
  3. S

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

    I will represent my blank spaces in the expected output of the text file with S, so I would like my output to be. Field 1 pulling from my table as 14.25 and Field 2 pulling from the table as .25. I hope this makes sense? S1425SSSS25
  4. 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...
  5. S

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

    Thank you all! txtNumber was actually intNumber and the error I was receiving was trying to convert the integer to a string. I went ahead as June suggested to create a seperate textbox and it works great! Thank you :)
  6. 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...
  7. S

    Error on Query: Operation must use updatable query?

    So, I'm trying to take the information from that Totals query....and update the CheckStub record. Thoughts on how to do that?
  8. S

    Error on Query: Operation must use updatable query?

    So, I'm trying to take the information from that Totals query....and update the CheckStub record. Thoughts on how to do that?
  9. 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...
  10. S

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

    Thank you so very much! I've been starring at this code for hours! DUHHHHHHHHH moment for me!
  11. 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...
  12. 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...
  13. S

    Dlookup In Query

    Wow! I was overthinking that. Thank you Minty! This works so much better... SELECT CheckStubInfo.PatronNo, CheckStubInfo.[BF%], CheckStubInfo.SCC, CheckStubInfo.Bacteria, CheckStubInfo.[Protein%], Round(IIf((350-([CheckStubInfo].[SCC]/1000))>0,(350-([CheckStubInfo].[SCC]/1000))*[Pricing...
  14. 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%]...
  15. S

    I'm trying to execute this query to return a value from another table(GradeAQualityAdjustment)...

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