Search results

I have made a couple of posts about this and had no response as yet. Maybe i didn't explain it well. I have a form that logs emails. The emails are either "to" or "from" a person. I want to have two queries that pick out either to or from. Now each person i know sends me several emails...

Well it has been ages since i have used this site. I also :confused: haven't changed my personal database for ages and so am very rusty at Access. I have a form that i use to record emails received and sent from friends. I thought i had a good query filter to give the information i wanted but...

Hi there I want to avoid duplicate dates in the date field of my form. It's a little more tricky than it sounds though. Imagine two fields in a form; one list box of eleven values and one date field. Once i have chosen a value from the list box i enter the date in the second field. It is ok...

Hi there I have a report which shows the sales totals of ladies clothes for 11 shops. I have created the expression "=Sum([1 Ladies Clothes Sales])" to do this, my only problem is i don't know what to add to this expression to put the totals in descending order. Can you help? Thanks

Hi I am a beginner to Access and don't get on very well with Access terminology so please be gentle. I have a database that stores shop sales details. There are 11 shops and some of the fields include Date, Week number, ladies clothes sales, mens clothes sales, etc. Sales data is entered for...

I have a scenario where i have records that have an ID numbered field but i have deliberately given some records the same numbered ID (I won't go into why i have done this or i will be here all day explaining it). Anyway i have those records linked to a combo box. The field the records are in...

Thanks to people's help on here and another site i have worked out how to create cascading combo boxes and also how to use the not in list property. The puzzle i am currently working through is how to put the two together. It would seem that when you have cascading combo boxes something...

As we all know Access is an amazing programme with endless possibilies. Trouble is one of the things that stops me from doing a lot more than i can already is expressions. I just don't get it. I know there is an expressions builder and when i first saw it i thought, ok you just choose the...

Hi I am running a database that among other things, records the category sales of 12 charity shops. The categories are things like Ladies clothes, Men clothes, Kids clothes etc. I have a separate report for each category (about 10 reports in all). In each report each of the 12 shops are...

Hi I am running a database that records the sales figures from twelve charity shops. I use the database to record the monthly sales of different categories such as ladies clothes, mens clothes, kids clothes etc. I have a different report for each category so lets take the report for 'Ladies...

Again a question that i have seen asked before and again the answer contained lots of jargon i didn't understand. I have 3 combo boxes in the address section of my form; suburb, town and country. I want to use the combo boxes to limit each other as entries are made into the boxes. When i...

I know other people have already asked this question but all the anwers i have come across give lots of computer coding i don't understand. I have a combo box with some entries already in it but when i make a new entry i want to automatically update the source table the existing entries come...

This is the first of three threads i am posting. I'd say i'm pretty average at using access and have overcome most problems but i always struggle when it comes to getting over all the jargon that Access uses. I have looked through some of the Acess guide books but i have not found anything yet...