Search results for 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

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

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

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

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

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

Thank you very much guys. It worked

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

Thank you very much Steve. It works fine.

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

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

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

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

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

"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...

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

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

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

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

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