Using MS Access/Duplicate Values

Advertisement


Question
I have a Form the data source is from three diffenent tables Demand, Orders, Actions which displays the status of each demand if purchase order is placed and its current status.

One Demand having one or many orders:

DemandNo    OrderNo   Amount   Supplier   LastAction
001         001        100      abc       order placed
002         002        100      abc       waiting for shipment
002         003        100      abc       shipment received
003         004        100      abc       passed for payment

you can see above there is total 3 demands and 4 orders.

When I count the total demands ( =count [DemandNo] ) it shows the total as 4 but I want to remove the duplicate value and count the actual demand numbers enabling me to show how many demands received between specified period.

Your help would be highly apprecaited.

Thanks

Answer
Hi Sher,

I am trying a different way to answer questions, via video, thanks for bearing with me.

You can view my response to your question about unique values here:

https://www.youtube.com/watch?v=28lCtwpqWLk&feature=youtu.be

If you prefer text, I am currently having it transcribed, but it will not be available for 24 hours.  Just let me know as a follow up question if you wish to receive it as text.

Thanks

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Julie Misson

Expertise

My area of expertise is Microsoft Access 2000-2007. I have been building microsoft databases for the past twelve years. I would be competent in answering questions from novice Access 2000 users to the more advanced including VBA. If I cannot help, I am more than likely be able to point you to websites that can.

Experience

I have a Microsoft Access business where I build database for small businesses. These are usually one off designs, where there is no off the shelf software avaliable to meet the business needs. I also teach Microsft Access to beginners. I am the owner of the www.simply-access.com website.

Education/Credentials
Self taught in Microsoft Access. Have done some units in normalisation and SQL, but most of what I know I have learnt from books originally and more recently the Internet.

©2016 About.com. All rights reserved.