Search results

Hi, How would you place two reports onto one page side-by-side? The two reports each follow different queries, but the queries are derived from the same table. Therefore, I don't think Access will let me create a third query linking the data together into one query and one report. Any ideas...

Hi, I was working on a database on Access 2000. After I finished, I coverted it to the 97 version. but, for some reason, when i try to open two reports using 97, it gives me a message saying that it cannot recognize some of the data on the forms. But, the weird thing is that I can open other...

hmm...it still doesn't work. the problem is that i can't create a query that joins the two queries. it tells me that it can't connect the two

i'm trying to gather the sum of commissions from a trade table and then post them onto one report. however, the trick is, one column of sums (rows are labeled by sales trader names) is supposed to be the commission calculated for today...and the second column is the sum of the commissions for a...

Hi, just wondering if there was any way to make if...then statements or the likes of it in the criteria part for the fields in the query design view. I would like to make a field false and then have the data sorted accordingly if a checkbox is clicked on a form. If the checkbox is not...

I have to check a field on one table to see if each record corresponds correctly to names on another table. Is there any way to open two tables as open recordsets to compare? Or is there another easier way? Please help and thanks! =) genevx

Just wondering, but how would you go about declaring a variable as a database in Access 97. It works in 2000, but after I converted it to 97, it tells me that it doesn't understand the object. Please help and thanks! =P genevx

lol...thanks sooo much!

heya, ..how do you make a report or query run a specific number of records? I've sorted the data according to total commissions in descending order...but I want to pick the top 25 only of them everytime i run the query within a specified date range. I know this should be really easy...but i'm...

actually...never mind. god damn i'm stupid! haha

hello, ok...here's the wrap: A user inputs a date range and, using that date range, my query scans a table for transactions within the range. Some transactions might have the same company name for it. What I need is the sum of another field, commissions, for each different company name so...

Hi, I was just wondering what the command to set page breaks in word documents from access was. Is it something in the format of DocWrd.PageSetup.PageBreak or something like that?

heh...thanks guys...greatly appreciate it!

Hi, How do you get only the date with use of the NOW function and not with the time also? thanks

sorry about the previous postup...but i've decided to keep it within access. so, how do you program a button that combines the information from multiple reports and posts them into one window? sorry...but still a newbie at this. i'm sure it's pretty easy. thanks a lot! =P

I am currently trying to program a button that combines the information of several reports and sends and opens all the information into one Word Document. I have only been successful in making a Word Document appear for each report. However, I am completely baffled on whether or not there is a...