Recent content by dan_s

That's great! Thanks very much for the help - it's appreciated :) Dan

Hi, Sorry for being difficult... As i understand it, I hould have smething like CountofBus: Sum(iif(fldUsualTransport="Bus",1,0)) (?) Correct me if I'm wrong - sorry for the confusion! Dan

Thanks very much for the replies! There is only one table, and it can't really be changed. Brian... So that would be: Field: Car Criteria: CountofTransport1: Sum(iif(fldTransport="transport1",1,0)) (?) Sorry for the confusion - I'm fairly new to Access! Thanks Dan

The table holds data on members... Name, DOB, etc etc. There is a Lookup for mode of transport and there are 8 to choose from. I need to count how many of each mode of transport there are. Thanks in advance Dan

Hi, I have a table showing members of a club. I need to show how many members use each particular mode of transport. Dan

It's similar, but it will depend on the month surely? Is there a way to do it by month rather than days? Thanks Dan

Thanks very much! :D

Hi, I have a database showing car details, and need to show all records whose MOT is due within the next 30 days/one month (from today) It might be similar to my first question. Thanks in advance Dan

:confused:Hi, I'm quite new to Access, and would like help with a query. I need to show all records with the date field 14 days before todays date. If i havn't explained this clearly enough then i'll have another go. Thanks Dan