That code gives me a distinct count of the dates with values, not the distinct records for a particular day.
ie Looks Like
XRSC DISTINCT COUNT DATE 1 DATE 2 DATE 3 DATE 4 DATE 5
A 5
Hi there,
I'm trying to format a crosstab query to fit better to an excel spreadsheet I have. I have a query here:
TRANSFORM Count(*) AS TotalCount
SELECT IDXRAD_RFB_WEEKSTATS.XRSC, IDXRAD_RFB_WEEKSTATS.XDATE, Count(TotalCount) AS DistinctCount
FROM IDXRAD_RFB_WEEKSTATS
GROUP BY...
Hi,
I have a crosstab query which counts the number of exams based on day and dept. I am running code to automatically send it to excel however I need to create an array that will not change, depending on whether certain depts have data one week and not the next. I created a "dictionary" to...
Hi,
I'm trying to create a way to automatically fill in excel sheets from an access table. I built a test database just to try some things and see if I can apply it to some of my other projects. However I am running into an error with the range in the CopyFromRecordset line. My Code looks...
ok the four tables are
RealEstatetbl
TransactionDatatbl
Contacttbl
AddPlayerstbl
The system is set up that the first form is a search form. you click the search it gives you a few results and displays them with a link to click and see more. you click on that and you get the ResultDetailsfrm...
Ok I put that in and it says that I created an expression with no value and highlights the code from above. I must have to add something to cancel the code if there is no path?
Oh I'm sorry I confused you. No the above code works fine. I was just using that as an example of the code I've generally been using. Ok here is the code I developed for a command button on the transaction data form to create a report with it registering the same ID and transid to bring...
Hey thanks I think I'm party way there. However now I'm getting a different error. I created this code
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Not IsNull(Me![ImagePath]) Then
Me![CoverImageFrame].Properties("Picture") = Me![ImagePath]
Else...
Hey I am trying to create a cover sheet for a report in my database. I have placed an image frame on the report to call up the image path stored in one of my access tables. However I created a "default" picture that I want to put into my VB code to input it if no image path for a picture is...
Sorry to get back so late I was off yesterday
Here is the SQL for my query:
SELECT RealEstatetbl.PropertyName, TransactionDatatbl.TransactionType, TransactionDatatbl.Buyer, TransactionDatatbl.Seller, TransactionDatatbl.Broker, TransactionDatatbl.Lender, TransactionDatatbl.Developer...
Hey I have four tables that I am looking to collect into one report. I created a query and have combined all of them but now have to write the code in order to call up specific records based on id numbers. My original code to do this before with just 2 tables is this:
Private Sub...
Ok I've created this real estate database and have a search form process where by a person can type in an area and search for properties and get a list of them with details and such. However on the search details form I would like to allow people to click a command button and it automatically...
Ok I got it to work somehow. I deleted and remade the table column for the id, as well as using the replaced filter from above and it has seemed to fix itself.
Thanks for the help PHV and 1DMF
ok I think I have it targeted at the fact that the ID that is being used in the filter is a number data type. I found this when I went back into my backup and saw that it was working when it was a text datatype but when I changed it to number it did the same thing. I wanted to keep it a number...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.