Recent content by Goat.Cheese

I realise the post title is loaded, so i'll try to break it down. Keep in mind i only posses layman knowledge on the subject. I've created a form from a table/query which lists deliveries. Fields include, name of delivering company, product name, product shipping cost, product id. What i have...

Also, When i replace the ; with , in DatePart("yyyy";[Дата]) & "/" & Format(DatePart("m";[Дата]);"00") I get a syntaxis error.

But, i dont have a form. What i have is a table with client names, purchase dates and their value. And the clients'monthly purchase totals. So i need to create a form then? I tried creating the drop down menu by going into form design view, deleting the client names box and replacing it with a...

You replied to the wrong fella :D. I'll be able to try what you suggested tommorow, sorry for the late reply. One question: (Like Forms!frm_Name.cmbo_BoxName & "*" ) Should i copy it exactly like that or do i change BoxName with the name of one of my fields? Anyway, thanks.

Uhm...That stumped me. Change the criteria of what in the query design? All I use in the query is "client name", the sum of "sales total" and "Expr1: DatePart("yyyy";[Datefield]) & "/" & Format(DatePart("m";[DateField]);"00")" Still a layman at this.

What i have is a table with client names, purchase dates and their value. I also possess a query which shows the monthly sum total of said clients' purchases for the last year. What I need to do is create a drop down menu, in which, when a client name is selected, I could see his "monthly...

I've crudely assembled a paint image of just the 3 tables i need to work with. Unfortunately its access 2010 - is the 2003 better? http://img52.imageshack.us/img52/8497/gramc.jpg From left to right, the fields are: date - client name - Sale value There are a total of 170,729 fields which list...

I dont believe i see any function that will allow me to create a query regarding "sums" for the entire month. Clients | SalesTotal | Expr1: month([DateField]) | Group | Sum | Initiates a query which so far has taken 20 minutes to reach about 5-10% completion. Im stuck on this.

Date manipulation sounds a tad high-brow for me. Could I bother you for some instructions on how to do this?

My "Date" column is a text field that looks like this: DD.MM.YYYY Since the amount of data is very large, access query returns an error saying that it cant convert a field with more than 65,000 entries. Anyhoo, I need to find a way to show summed totals for the separate months, and for the...

Because the total record includes 3606 companies and one of them has a recorded one-time purchase that amounts to 0,4199 of the currency in question. I solved the pecentage equation, by saving the query result that sums the profits and totals from each company and used these calculated...

Company | Profit|Sales total| Expr:1 Percent: [F1]/[F2]*100 Group by | Sum |Sum | Returns an "overflow" error message. I read that it is probably because i tried division by...

I have 3 fields in the query. The first is the company name, second is a for the total profit made in sales i.e. the positive(or sometimes negative) difference between expenses incurred to have the item/s in stock and how much i have sold it/them for. The third one represents the sum total of...

Well, i decided instead of appending the data to a table, I'd just import it as an entirely new one, and just manually name the 30 fields. Worked with much less hassle and no errors. The weird text that was displacing the first row, seems to be the result of the wrong code type. Shoulda been...

I am fairly certain that its far easier for both parties to replace one symbol in a copied text, rather than archiving it, uploading it, and having people download it. And i wouldnt call my post "irrelevant" , If thats what you were implying.