Search results

SELECT tblDEALERS.DNameShort, tblSPFSALESPEOPLE.SALESPERSON, tblSPFSUBMISSIONS.SPFSALEID, Count(tblSPFSUBMISSIONS.RETAILSALEDATE) AS CountOfSales, tblSPFSUBMISSIONS.RETAILSALEDATE FROM (tblDEALERS INNER JOIN TblDlrPurchases ON tblDEALERS.DLRID = TblDlrPurchases.DLRID) INNER JOIN...

SELECT tblDEALERS.DNameShort, tblSPFSALESPEOPLE.SALESPERSON, tblSPFSUBMISSIONS.SPFSALEID, tblSPFSUBMISSIONS.RETAILSALEDATE FROM (tblDEALERS INNER JOIN TblDlrPurchases ON tblDEALERS.DLRID = TblDlrPurchases.DLRID) INNER JOIN (tblSPFSUBMISSIONS INNER JOIN tblSPFSALESPEOPLE ON...

Attached is my query design

I am trying to create a report that shows how many sales each sales person has in a 2 year period and sort it from the most # of sales to lowest. I want to show all sales people not just top 5 or 10 My fields are sales person and retail date.

I had closed the databases...just opened the one that has the linked table "Your Microsoft Access database or project contains a missing or broken reference to the file 'dao2535.tlb' version 3.5 *To ensure that your database or project works properly, you must fix this reference." under...

I have imported a linked table into the BE of another database. I have a calculated field that is Right (CHVIN, 6) which CHVIN PK 17 digits CHSHORT 6 digits - Right(CHVIN,6) which pulls the last 6 digits from CHVIN CHSHORT works fine in original DB but as a linked table it comes up as...

Relationships BE --> FE don't match. I have a split database. My backend Relationships aren't updating to my front end. How do I get my front end relationships to update to what my back end looks like? All tables are LINKED not imported. :banghead:

Thanks! Works perfectly!!

I have a date field that is just a typical date field. When I do a query, I want to look up by just the YEAR in that date field. Can I do that or do i need a separate text field with JUST the year entered in? or can i have a field in my table that just looks up the main date field and...

I need to get a hold of the webmaster. The contact page isn't allowing me to "contact" THANKS!

If it is a new customer, a pop-up comes up (similar form to the above mentioned) that comes up blank for adding a new customer.

that didn't work. it won't even pop up the form now. grrr

I did an unmatch query, then did an append from there to add only the records that don't match. Thanks! :D

I am moving information from one table to another to make the table appropriate. the old table wasn't set up correctly. I have now taken THAT table and made other tables that are based on the first one. The old one is still live until I get the new one finished but I have already imported...

I have one table of of 300 records and another of 200 If I do an "Append" query, will I be able to add the extra 100 records to table 200 to make it match the 300 without duplicating information?

Private Sub btnEDITCUSTOMER_Click() On Error GoTo Err_btnEDITCUSTOMER_Click Dim stLinkCriteria As String If Me.Dirty Then Me.Dirty = False stLinkCriteria = "[CUSTID] = " & Chr(34) & Me![CUSTID] & Chr(34) DoCmd.OpenForm "frmADDCUSTOMER", acViewFORM, , stLinkCriteria...

I have a sales form that contains a combo box lookup to tblCUSTOMERS. It allows me to select a previous customer if that person is already entered into the system. If the person is NOT in the system, a form pops up to add the customer into the table. What I need to know is, if the person IS...

OH. and how do i handle a change of address of a customer? I want it to flow as the same customer but keep the address history?

Yes, that is basically what i have. we sell motorhomes so I have my Vehicle ID number as my PK in it's table and FK in all other tables I need the VIN to link to such as who purchased it. I can't see how I can work in brochures as product.

tblOWNERS is currently OWNERID (PK) LEADID (FK - tblCUSTOMERS) CHVINID (FK - tblCHASSIS) NUMRETDATE (Numerical Retail Date)