Search results

  1. M

    Query to pull Fri Sat Sun occurences in a specific month

    You are a genious!! Thank you so much.:)
  2. M

    Query to pull Fri Sat Sun occurences in a specific month

    Do you mind spelling this out for me? I've looked at the link, but not getting it... in my Confirmed Date column of the query is the criteria Between#6/1/2014# and #7/1/2014#. In the blank column to the right, I would type what to get just Fri Sat and Sun occurrences?
  3. M

    Query to pull Fri Sat Sun occurences in a specific month

    Access 2007 query that has a specific date range between #6/1/12014# and #7/1/2014# returns the date I need. How do I now get it to pull just occurrences on Fri Sat and Sun of the month of June?
  4. M

    Data for 12 Months by Person

    No criteria in the cross tab query. 2012 is in the criteria in the Year ([Confirmed date]) column that the cross tab is pulling data from.
  5. M

    Data for 12 Months by Person

    Yes, but I need all of the procedures for 2012, even if the dates are the same for the same physician and patient. The Cross Tab is ignoring these, but I need all of them to be counted as well. How can I make the Cross Tab recognize every procedure listed in the query? Example, in the select...
  6. M

    Data for 12 Months by Person

    Putting Like "*2012*" in the Confirmed Date will not bring back every date listed. If there are two procedures dated 1/25/2012 for a physician and a particular patient, only one procedure is returned, making the count incorrect. Anyway to correct that in a query?
  7. M

    Data for 12 Months by Person

    Thanks to everyone who was looking at this with me....I figured it out. I created a separate query for just year 2012 and then crosstabed that query. January is showing up now, so if in March, February will show up...I will be in business.:)
  8. M

    Data for 12 Months by Person

    I've been working with this crosstab query and the data is exactly correct as the corsstab stands originally. My table has several years of data. How can I just pull out the months of year 2012?
  9. M

    Data for 12 Months by Person

    The crosstab query gives me the layout I need. How do I get the criteria to bring in the count each month individually? I've tried entering the ([Confirmed Date])=Year(Date()) but that is not working. Is there a formular that will recognize the month I am in (when running the query) and put...
  10. M

    Data for 12 Months by Person

    How would I get 12 months of data laid out like this in a report? I can design the report, but how do I get the individual data from a query? Would I have to make 12 queries for each month? Then how do I get that information into one report? ...........Jan Feb Mar Apr Name 1 276 260 270 280...
  11. M

    White Space in a Report after Hide Duplicates

    I need for the report to show the procedure name one time with the total (see the ankle brachial index is showing six times?) I want it to appear one time with the total of 6. Copy Of Echo by Technologist qryTechnologistProcedureAccessTotalsProcedureADMINISTRATOR, PROGRIS ANKLE BRACHIAL...
  12. M

    White Space in a Report after Hide Duplicates

    This is not working either. I've created the totals query, totaling only the procedures for each tech. I've made 'hide duplicate' yes, 'can grow and can shrink' to yes.
  13. M

    White Space in a Report after Hide Duplicates

    My report is totalling after each procedure type and I have told the properties to 'hide duplicates', but the white space is still showing on the printed report, before the total. How do I remove the white space and keep the totals? I meant to include that I am using Access 2007.
  14. M

    How to use a default value expression

    I can tell this is not going to be easy!! There will be 20 different line items that will import the unwanted way. The procedure type currently is in a table by itself, along with the applicable fee, and we use that table as a lookup table to create a check request. Always what is wanted in...
  15. M

    How to use a default value expression

    I do not understand how to use the default value expression. For instance, I am importing an excel spreadsheet into an Access db. I need for this field Abdominal>ABD & PEL DUPLEX SCAN LIMITED to default in the database to ABD & PEL DUPLEX SCAN LIMITED How do I do...
  16. M

    Parameter Value in Report

    I also want the keyed month name to appear in a field on the report. I may have confused what I need as the end result. Right now the report design looks like: [Text Box 1] Services Rendered in [Text Box 2] = [Date] [Text Box 3] 2010. When I key in the month needed in the paramenter, it...
  17. M

    Parameter Value in Report

    How do I make the parameter value show "Key in the Month"? Right now it displays Date and it works fine, but I want the instruction to be specific.
  18. M

    All Data does not Print That is in a Label

    Thank you. It was a little complicated for me, as I did not design this program. I was working through a switchboard. But what you asked me did trigger a thought and I figured out how to get to the design view of the report and found the problem with the properties. Thanks for your quick...
  19. M

    All Data does not Print That is in a Label

    Can you please tell me why all of the data that is showing in a label does not print. Only the first line prints. The data does not appear in Print Preview either. The label is designed to type a Vendor Name, press enter for the second line (if needed) to add additional addressing information...
  20. M

    Label Alignment

    Can you tell me how to make the labels in my access report to appear in the same diaganol alignment as in the attached sample excel spreadsheet? Thank you
Back
Top Bottom