Search results for query: *

You'll be pleased to hear that I've reworked it all so that I'm not using a lookup in my vendeurs table any more but just a relationship between the Vendeurs tbl and Equipe tbl - it is all as it should be, nice and tidy

Yes my issue is resolved thank you Picking the Equipe from the Combo box didn't seem to work when i tried it - it was just displaying the Primary key again for the Equipe - I believe as the Lookkup in the Vendeurs table for this field is the two columns EquipeID, Equipe with Column width set to...

Thank you btw- i needed to delete the relationship between the Vendeur tbl and the Equipe tbl then amended my query it works

Regarding my tables - no - I have no duplicate information in tables The information is only stored once using FK's and in the case of the Vendeur Equipe a lookup in the from Equipetbl into Vendeurtbl

All the lookups are fine apart from the Equipetxt I think it has something to do with the fact that in the Vendeur Table the Equipe Field is Looking up from The Equipe Table, SELECT Equipe.ID, Equipe.Equipe FROM Equipe; With Column width 0" to hide the Primary key from the Equipe Table - so...

I am trying to lookup the second column in a combo box to auto fill a form using the AfterEvent Update Me.VendeurID = Me.PickCombo.Column(0) Me.FirstName = Me.PickCombo.Column(2) Me.Emailtxt = DLookup("[Email]", "[Vendeurs]", "VendeurID = " & Me.VendeurID) Me.Equipetxt = DLookup("[equipe]"...

Thanks - I actually managed to create an unbound text box for StartDate and EndDate on the Form then in the Criteria for the query I put Between [Forms]![Sommaire_Vendeur_Date]![Startdate] And [Forms]![Sommaire_Vendeur_Date]![enddate] This now runs the query from a form when two dates are entered

I was hoping to add two boxes to the form StartDate EndDate and then have criteria in the query Date field I don't know what this criteria should be

Thanks for such a quick reply Does this enable me to enter the date range in the form? the code seems to reference a report I wanted to have a form where the user selects a date range from a query

I have managed to create a Report from a form that displays data per date In the query criteria for the date it references the form [Forms]![equipe_form]![Date de Vente] The report is based on the results of the query as per the information entered in the form so far so good However, I want...

solved Me.Emailtxt = DLookup("[Email]", "[Vendeurs]", "VendeurID = " & Me.VendeurID)

Thanks So much - Here is the Relationships image you requested any other screen grab you think will help is but a click away The Equipes are in a ComboBox (Paris, Beneluxe, Marseille, Lyon,, Callcentre) so i think this is why it may be returning an error So I tried with just a txt box -...

If Only! Have now put the teams into the vendeurs table to try and simplyfy things ComboBox, no problem, pulls Last name, and have got it to afterupdate fill first name and vendeurID - HOWEVER the Equipe (team) only updates the first time i use the combo box and no amount of clicking on the...

Since posting yesterday afternoon, i've been working on it some more and Have created a query [Vendeur Equipe] which has 3 fields [VendeurID] - [Equipe] - [Last Name] in the AfterEvent update of the combobox Private Sub LastNameC_AfterUpdate() Me.FirstName = Me.LastNameC.Column(2)...

yes vendeurID is unique and each vendor has only one team assigned

really hoping this will work, with the code as you've put it amd getting an error that the sytax of the subquery in the experssion is incorrect. check the subquery's syntax and enclose the subquery in parentheses

I have created a combo box SELECT Vendeurs.VendeurID, Vendeurs.[Last Name], Vendeurs.[First Name] FROM Vendeurs GROUP BY Vendeurs.VendeurID, Vendeurs.[Last Name], Vendeurs.[First Name]; This successfuly returns the first name and last name, and i'm able to autofill a text box with the first...

Hello, I've been trawling the web trying to find how to build the expression to rank how many machines an individual has sold by date and to assign points for the ranks - so he who sold the most 6points, 2nd 4 points, 3rd 3 points, 4th 2 points 5th 1 point. This is how my query is set out...