Recent content by darth sidious

The table holds music groups who have been voted for like XFACTOR. What I am trying to achieve is create a form that lists the top three acts in order of votes and then have a field next to it showing the position each has finished(autonumber or rank). I will also have an additional field on the...

Can the autonumber be created on a form too? If so how?

Hi Your database does not open. It thinks it is a php file???

I just had a an idea after doing some research is there a rank function I could use in this query that will give me the rank based on number of votes received????

Hi I wonder if there is a way of using expression builder to get an autonumber field in a query. Also can it be done on a form?

is there no way in expression builder to generate an autonumber in the query

Each time I run the query I would want the tabled to be wiped and new data to be added. If I append to a table it will just add on to the previous data right???

Hi I have a qryResults which I would like to add an autonumber field to but have not managed this with any success. Please look at attached DB and qryResults, any assistance with this is much appreciated. Thanks Darth

Hi Thanks for the assistance. That worked!:)

Basically what im trying to do is add a record for all actid that have a vote of greater than or equal to 3. This will be inserted as round 3 with nothing in the votes field as later when voting takes place for round 3 i can update it after votes for round 3 take place. Therefore all new...

Roundvotes value will be left blank as will be updated later after voting takes place.

I’m trying to create an append query where a new round is added to each ActID where the Round Vote is greater than or equal to 3. I know this query will only add 1 record in the form of RoundNum, RoundDate and Round Description to the bottom of the table. Please help! please look at the attached...

All data is made up and not real. Il post with database attached in the morning. thanks

Still struggling with this

I have an option group