Search results

Googled, found some things. I think this is exactly what I'm looking for, thanks. I'm probably gonna take a long time to achieve this, but glad to know what I want to do is possible after all :)

I want this query to count all of the different types of order (Clase de Orden) and if a type of order isn't found, to return zero. How do I do this using IsError, since when it doesn't find an order, it gives me an error. This is the query: TRANSFORM Count([E 025].Porción) AS CountOfPorción...

Yes but when there's tons and tons of different supervisors and employees it's a very, very long summary. Is there really not a better way to accomodate this and make it look like I mentioned? With the types on top and the quantities under?

Okay, let me try to explain this better. I am making a report to summarize what types of orders have been made. From that report I will be able to click on the fields (the count values from every type of order) to see the information regarding that specific order type. I have the table from...

My order types are categorized as "OC01", "OC02", "OC03", etc. Those are values that come from a column named "Order Type". It is cross-tabbed so that "OC01", "OC02", "OC03", are turned into headers and under it is just a number counting how many times each order "occur". When Access doesn't...

So I am working on this database and it has to do with orders. There are about 15 different types of orders. We download data daily, and replace the source of our Access data from Excel as we download it every day. Problem is, some days we have all 15 types of orders, some days we don't have...

I have checked it out, and decided to make this file my main project, since I can't be bothered to find that filter you mentioned. It is working wonderfully. One question though. If I were to copy the main report, paste it and add a different crosstab query as its Record Source (same exact...

Alright, thanks.

Here's the zip: https://drive.google.com/a/upr.edu/file/d/0B_e8buRlLVTmQVhrVWRxQi1VTk0/view?usp=sharing_eid remove parenthesis, obviously. This is a very watered down version of my data; usually it has 5 main tables (like E 037). The only "working" order type is "LECT". The filtering code is...

...I probably am. I'll have to install Access at home so I can send you a zip. The forums won't let me upload or post links since I'm fairly new here. I don't know how much of an option it is for me to change the multi value field thing, since the source is an Excel sheet that changes all the...

The first option didn't work. I did that and when I went to open the report I'm trying to get these details on, it just prompted me to enter parameters. Tried the second option, only found one error and that was with a "viewForm" I put in the Close button. I feel stuck :| For some reason I...

1. yes, I removed it. 2. there is nothing in the filter property. 3. and yes, allow filters is set to yes. Yes, if I open the report directly I get all the records there are, not just a particular user or order type. I tried adding the [E 037], no errors, but still blank. This is the main...

Alright, error is gone. Now it's pulling no data at all, only giving me blank reports XD PS, hope I'm not being too annoying:p

I know that, and I modified it. It just gives me a compilation error for some reason. This is exactly the code as I used it: DoCmd.OpenReport "rpt OC01 Details Aguadilla", acViewReport, , "[Usuario]='" & Me.[Usuario] & "' AND [Clase de Orden]='" Me.OC01 & "'" It gives me a "Compile error...

Tried this, and it gave me a "Compile error: syntax error"

Here goes. The code I'm trying to use is: DoCmd.OpenReport "rptName", acViewReport, , "[Username]='" & Me.[Username] & "' AND OC01='" Me.OC01 & "'" Which for me is: DoCmd.OpenReport "rptName", acViewReport, , "[Usuario]='" & Me.[Usuario] & "' AND OC01='" Me.OC01 & "'" Yes the field name...

I agree. The reports for each order type are the same. However, it always gives me an error when I try to add a second filtering criteria. This code is currently working exactly how want it to, minus the fact it's not filtering order types DoCmd.OpenReport "rptName", acViewReport, ...

UPDATE: did DoCmd.OpenReport "rptName", acViewPreview, , "[Username] = " & Me.[Username] And it prompts me to enter a parameter value. However, the prompt tells me the Username associated with the field I clicked. If I type in the same username that is in the parameter input window, it...

Tried the code out, it still won't filter by username. Same problem but now it's on report form :/