Search results

I'll take a look. (At first glance, it is 2003)

Oy....I'm not seeing those options. :confused: Are those in Access 2007?

I started to "toy" with making some other reports and had a report query appear that allowed me to add the summary queries to it...since I was just toying, I only added a couple. How can I add more? I can't find the report query.

I've created summary queries for each of my queries that only display the Total Number of the items in the query and the Sum of the Dollar Amount. I then tried to create a report that would use those figures. I started with a blank form and added a text box and use the property sheet to select...

I can't get this to work properly. I added the textbox and count get the total to appear, but I also would get all of the records from the first query...which I don't want. I also tried to create a report and include all the necessary fields for each of the queries, but that seems to have an...

Actually, I don't have "Totals" fields in the queries...but I did use the Totals/Sigma in the datasheet view to display totals. Is there another way?

This is probably a REALLY stupid question, but... I have several queries that I would like to have the total number of records and the sum of the $ amounts of those records/queries appear on a report...being new to Access, how is that done? :confused:

I figured it out! I had closed the Form. I thought that the date(s) entered would be retained. It works fine when I leave the for open. :D

OK, so I created a form called Date_Entry which has a textbox call Start_Date (formatted as short date0 I put this in the criteria and it doesn't recognize it when I "run" the query. <[Forms]![Date_Entry]![Start_Date]

Thanks for the info. Being relatively new to Access, I'll need to research how to implement this and move forward.

Not sure if the is the right area, but here's my situation. I have a huge table that I import into my 2007 Access db. Then within access, I have multiple queries that I utilize on a weekly, monthly, quarterly basis. Would it be possible to somehow change/indicate the start/end dates that are...

I have a query that I am working on which the table includes Date1 and Date2. I want to create a query that will return all instances Date2 is either = Date1 or is upto 3 days after Date1. I've tried using this type of coding, but I suspect the "+1" isn't correct for a date. [Date1] +1 =...

Expanding on that idea... =choose(Right([Quarter],1),"January","April","July","October") AWESOME! Thanks!

Of the several fields that I have on a report, I have 2 that I am concentrating on...1 is "Quarter" and the other is "Month1". I am trying to have the Month1 label appear as "January" if the rightmost character in "Quarter" is a 1. I suspect this is fairly easy, but I haven't had any luck...

OK, so I'm working with Forms. I have a Customer table and a Form that I am using to fill Volume table. I have created a Combo box to "lookup" and select the Customer Name from the associated table. However, when I look at the datasheet of the Volume table, it is filled with the Customer ID...

Thanks, I'll give this a try. :)

Yeah, I assume it's not normal, but it's just the Top 10 Customers for that Quarter. ;)

OK, so I'm trying to accomplish a similar situation on a query. I have a table that each row contains 10 different customer ID's. I then have a single table that has the customer ID's and associated name. How can I create a query that will pull in the name for each of the 10 customers based...

I'm sure there's programming/theories that I will learn, in addition to this. However, I am just learning (via a book I am reading). I am only in the early stages learning about tables and relationships, and haven't gotten into Forms, Queries, etc... :o In my playing outside the lines and...

Hello, I'm VERY new to working in Access 2007, so this might be a stupid question. :) Is it possible to merge the FirstName and LastName fields from 1 table when using a multi-value lookup in a different table? If so, how?