Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Monzer

    Update query

    Hi; I was trying it only with one record. Its original ID was 200 and after I ran the update query it changed to -1. Thanks
  2. Monzer

    Update query

    Hi PHV; The query didnt work. It updated the ID field to -1. Thanks
  3. Monzer

    Update query

    Hi; I cant beleive that I cant solve this one!!! I have an update query and its going to update several fields based on parameters. Its all good and working fine except one field. Its the ID field, I just want it to update this field by adding the letter "R" before the ID number. EX: if...
  4. Monzer

    Update query

    Its a very simple field. Its set as a primary key,text(50). All I want to do is add the letter "R" to the contenant of that field. My update query updates (date,checkBox,ID). Thats all to it. Thanks
  5. Monzer

    Update query

    Hi; I cant beleive that I cant solve this one!!! I have an update query and its going to update several fields based on parameters. Its all good and working fine except one field. Its the ID field, I just want to update this field by adding the letter "R" before the ID number. EX: if the...
  6. Monzer

    syntax help

    Hello everyone; I have an append query that appends all the requested records to a table for processing. Here is my question. I have a feild called[AccType]for checking or savings, when running the append query I would like the data in feild[AccType] appear as follow:if checking=P and if...
  7. Monzer

    date formating in a query

    Thank you very much guys. It worked
  8. Monzer

    date formating in a query

    Hi everyone; I feel so embaress for the question I'm going to ask. Its been a really long time since I worked with access querys. I have a feild in my customer table called[SaleDate]mm/dd/yy, now I need to display that feild in a query as followed yyyymmdd. Someone told me I'd be better off...
  9. Monzer

    Count query (loosing my mind)

    Thank you very much Steve. It works fine.
  10. Monzer

    Count query (loosing my mind)

    This is the SQL statement SELECT tbl.[Customer Phone], tbl.[Call Date], IIf(DateDiff('d',[Call Date],[BillingDate])>=14,1,0)+DateDiff('d',[Call Date]+14,[BillingDate])\30 AS NumberOfCharges FROM tbl; It results in an error, any suggestions please. Thank you
  11. Monzer

    Count query (loosing my mind)

    Thank you for you response Steve101. I keep getting an error msg "You tried to execute a query that dose not include the specified expression as part of an aggregate function" ANY HINTS.. Thanks
  12. Monzer

    Count query (loosing my mind)

    Hope someone could help me with this! In my customertbl, I have 2 fields that i use to run my query.. [OrderDate] & [BillingDate]. First payment is due 14 days from[OrderDate]and this will automatically update[BillingDate]with Date().From there I bill a customer every 30 days from the...
  13. Monzer

    Who's up for a chalenge

    Question:How can i do it? When ever i enter a value the code should calculate it and add it to the "Amount" feild in my customertbl
  14. Monzer

    Who's up for a chalenge

    I have a feild "Amount" in my Customer tbl; Now in the customer EditForm i have a buttom called BackCom for commisions; the buttom opens up another form with the "BackCom" feild for input and the value inserted in this feild will be calculated as folow...
  15. Monzer

    Who's up for a chalenge

    "Amount" is the commision that i get payed on in my main table. Every week i get stats for my clients concerning their payments,a client is alowed for weekly payments instead one full payment; now,i get 10% comission each time a payment is made rgardless... Example: CustomerA payed...
  16. Monzer

    Who's up for a chalenge

    I have a feild "Amount" in my Customer tbl; Now in the customer EditForm i have a buttom called BackCom for commisions; the buttom opens up another form with the "BackCom" feild for input and the value inserted in this feild will be calculated as folow...
  17. Monzer

    Dcount issue!

    Never mind Paul it works Thank you very much,you really helped me. Thanks a lot.
  18. Monzer

    Problem with count function

    Never mind Paul it works Thank you very much,you really helped me. Thanks a lot.
  19. Monzer

    Dcount issue!

    Thanks Paul but the result is 0(its not counting),i'm sure there's something missing.
  20. Monzer

    Dcount issue!

    I have a report that pulls out all sales for certain dates, my problem is: i have a field "amount",i need to count how many are at 299.99 and how many at 229.99 in 2 unbound-text box. =IIF([amount]="299.99",count([amount]) Thanks...

Part and Inventory Search

Back
Top