Search results

question #2 re: tblCUSTOMERS. How do I handle the people who have requested brochures multiple times? perhaps every few months or years. I would end up having duplicates in my table.

hence the tblOWNERS? but if the new owner ISN'T in brochure requests then they are added to the brochure requests table (which is actually called tblCUSTOMERS) then added to tblOWNERS as a product purchaser.

would the product ID be an ok status indicator? they need to be able to have multiple product id's under each should they purchase multiple over the years.

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've watched the YouTube about subforms. I have Tab #1 which has my first point information from table #1 I have Tab #2 which has a subform on the second point of manufacture information from table #2 I have Tab #3 which has a subform of Options from the Options table. I need it to be a drop...

SORRY! Yes! Worked great!!!

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

but if I'm generating my February report in March how do i get it to say february?

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:

the file won't delete.

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:

and where/how would I enter "Max of repdate"?

For RepDate. Use date field i presume. And enter the start date of the rep or the end date of the rep?

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?

I always try in Print Preview. Tried the MayaMana code and got Run-Time error "13" Type mismatch

sigh. sorry Paul. I was clicked on the wrong square and was looking at the report event tab instead of the detail tab. I had been staring at the screen most of the afternoon and eyes were buggy. I'm fresh this a.m. I tried "On Format" in the DETAIL section (just like you said) and it still...

I've selected the Events tab...there is a lot of events to chose from

i did. sorry.. which event?