Search results

have solved this problem by getting rid of it. it over complicates more basic functions. for instance if i have 2 identical bottles (some times i can have up to 12 of the same bottle) each one would need its own record. making the simple process of taking a bottle out of the system more...

i havn't gotten too far into this project so any suggestions are possible. I am writing a database to track our (and others) wine collections. i'm wanting to track what bottle is where. so i can look up what i have, look up where i have put it and away i go to get it, simple right? just to...

Swapped out dlookup to dcount and worked a treat thanks. seems it doesn't like having the [] on them

Once more i am having trouble wrapping my head around Dcount. I have a survey, the results are stored in TblSurveyClients. i have a field in there called location, one result is Tokoroa I am trying to make a form to track how many people have responded from each town. i have an unbound box i am...

After days of searching it seems i am attempting the impossible. what has come out as a solution is using the browser on the tablet to open a PHP version of the form (hosted on the server). at this stage the database is complete, but will be split for roll out. is there a difference between...

won't let me save it as an older version sorry. this is the 2010 verson

Sorry for being a pain. I have a working totals query. SELECT Count(TblCadets.ID) AS CountOfID FROM TblCadets WHERE (((TblCadets.Rank)="U/O") AND ((TblCadets.Gender)="Female") AND ((TblCadets.Active)=Yes)); i also need to find other combinations, other ranks and genders ect. is there some way...

had a look at that. have been trying to break it down and tackle it bit by bit. Expr1: DCount("ID","TblCadets",[Gender]="Female") is what i have so far, it's returning 3 entries under expr1 2 of them (the ones set to female) return a count of 3, the male in the list returns a 0

I need a way to get a count of records matching multiple criteria. Table: TblCadets Criteria: [Rank] = U/O, [Gender] = Female, [Active] = yes the table at the moment has 1 matching record. this my be the sticking point. the number then needs to be able to be exported into an existing excel...

Hey all. I am building a database for a small training organisation. the database takes attendance at the moment, but i would like to migrate this to an android tablet. at the moment the roll is taken on paper, then given to someone to put it in the database. would like to skip that step so...

Query 1: finds courses from the ATP table and adds those results to the combo box on the form. Query 2: finds people who meet the requirements to attend those courses. EDIT: had a think about relationships and removed the query that populates the combo box from the append query. works fine...

Galaxiom, no they do not. they take data from 2 completely unrelated tables. the append is to add them to a relational table so i can then fill out the required report (as a form letter)

I think you might be on to something there Galaxiom. any ideas on solutions? JamesMcS: would that not limit it only to what is at the top of the list? i need to be able to select what course i need from that box.

SOLVED: Append Query: Making too many records. I have 2 append queries behaving in a similar manner. one of the values i need to append is from a combo box on the form. it appends the correct values to the table but the number it appends in equal to the number of values in the combo box...

i have an issue with a query i am running. the idea is "this list of people can do this course" you click on who you want to do the course and i will work out the rest of the problems from there. but everytime i check "tempattend" i get this recordset is not updateable. could it be because the...

excuse my ignorance but i'm not seeing how that suggestion is relevent to my original problem. are you suggesting that on my upcoming courses for i add a list/combo box to display the results of the course finder? have added a photo to hopefully help explain where i am at

SNCO FINDER SELECT [Personal Info].Rank, [Personal Info].[Last Name], [Personal Info].[First Name], AttandacetrackerQuery.Paradecount, Age([Personal Info]![DateOfBirth]) AS Age, [Personal Info].Prof, [Personal Info].Basic2, [Personal Info].JNLDR FROM AttandacetrackerQuery INNER JOIN [Personal...

the critera for each of the courses is vastly different. SNCOfinder does the same thing just looking for different critera

had a look at that site, that looks good for the next step of my problem. at the moment i have a query that returns upcoming courses. on each line it has a button to find people for that course, it will run the query related to that course checking who meets the critera to attend that course...

finally got the condition thing to work. i was trying to link it back to the base query the form was built off, but it wanted to be linked to the form to get the result