Search results

Hi I am trying to create a lable for a report showing the current week but I cannot seem to get it right. I have found this on Microsoft but it has the field [Salesdate]. As my lable isn't based on anything I cannot seem to get it to work Year([SalesDate])* 53 + DatePart("ww", [SalesDate]) =...

Can anyone point me in the right direction please. I have tables with sales reps, orders and order details. The commission % is always the same for all reps, I would like to have a report for current week or current month or current year sales and commissions for each rep. I can't seem to find a...

Works perfect. What a fast response. Thanks

Thanks for taking the time to view this question. I have a field (a currency field) that is $0.00, is it possible to have a check box (unchecked) and when it is checked it will change the $0.00 field to $20.00. The field will always either be $0.00 or $20.00. Thanks

Nothing will be stored this is for reference only. Thanks Kim

I have attached a very basic example for you to look at. What I am looking for is to choose a field on sheet 2 i.e. C2 or any in that column and then when I go to sheet 1, whatever was chosen on sheet 2 will appear in cell C5 and of course all the other cells on sheet 1 will actomatically...

Thanks for taking the time to read this, hope you can help. I have an excel workbook that calculates the final selling price for items I buy after various calculations have taken place (the calculations are dependant on the figure that is in cell A4 as an example), i.e. labor costs, lighting...

Perfect, worked a charm. Thanks for the speedy reply

Can anyone help me please. I have a telephone field that has been imported from many different databases and the format is different in some cases and i need to have all of the fields the same as in 00000000000 in other words no spaces or brackets. Some of the numbers are (00000) 000000 or...

Can anybody point me in the right direction. I would like to send selected customers a letter every so often but I'm not sure how to accomplish this. Do I compile the letter in a report format using a label box? if so how do I add fields to this? Plus how do I add just the customers I need...

Managed to sort it out by running the analyze performance button and this fixed the problem. Hopefully this will help if anyone else gets the same problem. Kim

Thankyou for any advice in advance. I have a basic customer and orders database CustomerID pk Name Address City ProductsID pk Model UnitPrice QuantityInStock Description OrderID pk CustomerID EmployeeID OrderDate DeliveryDate PaymentRec OrderDetailsID pk OrderID ProductID Quantity...

Hi hope someone can help. Thankyou in advance. I have a small database for my warehouse that sells washing machines, fridges etc. I am trying to get a grip on the stock control. What I am looking for when a order is filled out on our order form is the stock number will reduce by the amount...

Thankyou for your reply but I have managed to figure it out by linking it to Access. Thanks again.

Hi, not sure if there is anything that can be done. I receive a list from my supplier in excel each week with model numbers in column C (usually about 40 rows) but they do not supply what those code mean (they are product codes). I have separate product list that I then have to match up. I match...

Perfect, thanks for the speedy reply. Works a treat.

Hopefully someone can point me in the right direction. I have a very simple db for customers and sales. Tables are as follows Customers: CustomerID, Name, Address etc Products: ProductID, Model Number, Unit Price, Description, Cost Price Orders: OrderID, CustomerID, Order Date, Delivery Charge...

Thank you Gemma. As there are so many model numbers or serial numbers it would take the user too long to scroll thru so I am looking for a way to do a search for the code number and then return all of the components for that particular code number. The order items are in continuous form and no...

Thank you in advance for any assistance you be able to provide. I would like some help on searching for product codes or serial numbers and formatting this into an order form a current customer form. I have 4 main tables CustomersID (PK)– Name, Address, City, Post Code, Tel Number OrdersID(PK)...

Thanks Gemma that would appear to be just the ticket. Sorry to say as I am a newbie to all of this I cannot seem to get this to work. Any other advice you can give would be most appreciated Thanks Kim