Search results

I've been trying both last and Max in various combinations and it doesn't seem to work. If you have mentioned in other threads why Max is better to use in other can you give me a clue where to find them? I'd also find it really useful if there was something that explained a bit better what max...

Thanks for your help, I tried what you said. I think i do properly understand what you descibed but i get the feeeling it might be something more sinester than i originally thought. Sometimes the CommunicationType field and also the ToFrom field are correct and other times they are not. If...

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

Rich Any more suggestions in light of my last post?

I'm by no means an expert but i think this can be done by making the "default value" for the field in the design view of your table "0" :)

To change the form to how you describe would mean some work, for which i haven't got time right now (but will look into later). Are you saying it is not possible to achieve what i want with with the query the way my data is structured? Also if i were to use lookup boxes for each of the 10...

I think you are describing what i have already done. Something hasn't worked though. I have attached a screenshot which shows what i have in design view. The result of the criteria in the design view gives almost what i want but instead of getting one week for each shop and it's total i get...

I have a week number field because it is the only way i know to group all daily records into weeks. Now that i can group daily records into weeks i want to sum them as described above.

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

Working with images in a database without bloating it Hi I spotted the above and had a go. I'm a beginner to Access so even the simple things tax me a bit. The database seemed pretty straightforward but i couldn't work out how to have a separate picture appear for each record. I understand...

well i think i may be heading in a different direction with this now anyway. I have however been working on this darn cascading combo box database for the past week now. I have 5 combos that are linked. I also now know how to automatically update the underlying table when i add information...

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

Hmm ok i'll give that a go, sounds a bit tricky though with my limited experience

Thanks for your suggestions everyone :)

Halfway there Thanks for taking the time to put things into access dummy terms, it helps. As it happens i found what appears to be another way around the problem. From another source of information i found (didn't even notice before) that when creating a report with the wizard you can choose...

"You would have to use a totals query and base the Report on that, as an aside you don't need separate reports for each category, you can use criteria in a query or the Where clause of the open report method" I'm getting a bit lost. I already have a query that does what i want and i think the...