Recent content by Monzer

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