Recent content by MarieD

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

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?

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?

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.

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

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?

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

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?

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

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

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

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.

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.

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

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