Search results

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 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:

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!

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?

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...

I have a table of people who have requested brochures. If they actually PURCHASE our product should they go into a separate table called tblOWNERS in which I also want it to look at the list of people who requested brochures. if not where would I add them so I don't have duplicate information...

I want to create a form that incorporates a number of different tables & tabs. When I switch tabs (which represent the information on the different tables) I need it to be consistent with the main table and all the information that follows it from the different tables. I've been told the best...

I have a report that gives me how many records were in a period that gives me a count by state and a field that gives me a total of all but I need one that tells me OF those 24, how many were diesel and how many were gasoline make sense??

I need to put a date field in that is the month and year of the reporting period... for example February 2013 and then another date field that is the 10th day of the month following the reporting period. example: March 10, 2013 I have tried a number of different formats and can't get it right.

I have a table that has the "+" sign beside each record allowing me to "drill down" or expand the selection to see related information. It has the "+" sign in the table in the BACK end but not in the linked table in the FRONT end. All my other tables do.:eek:

When I open my LACCDB file in Notepad to see who is in it, it says I'm in it...3 times and yet I don't have access open. How do I get rid of this without rebooting my computer?:banghead:

I have a table of Dealers. Each dealer has a REP. I want to CHANGE the rep of the Dealer going forward but RETAIN the historical. How do I do that?

:banghead: I've tried 3 different codes and can't get my VBA to work... I have a report...on this report I have a label. I have the visibility property set to NO. BUT....IF the "FUELTYPE" combo box on the report is "DIESEL" then I want the visibility to change to YES Eyes are bugging out....

I have a report that I inserted a background image and when I try to insert a field it goes to the top of the report page, extends the width of the page and won't move.:banghead: What's going on?

Hi, I have a report that works great! I added a new model to my table "tblModels" today. It is set up EXACTLY like all the other models. When I run the report with the new model I get #Type in the Model and no results anywhere else...if I use the SAME vehicle but change it to a previous...

I'm looking for suggestions to speed up my report. So far I have 4 subreports in my report and 3 out of 4 of them have images that I have fields overlaying the image. I still have 4 more pages to add...and that is just for one report. I still have 2 more reports that will be 3 and 6 more...

When I double click the report and open it manually, the report comes up fine...except it comes up for ALL 9500 records. When I use the button on the form (which used to work fine) to print the report for ONLY the CURRENT record, I get a blank. Here is the code for my button Private Sub...

I want a warning message to pop up if the data entered into the field isn't a certain number of characters. What's the best way?:rolleyes: