I am designing a simple db in Acc2007 but with the old file system (mdb). I have added 3 test records. The report is based on a query but only one record is...
Robin- Oh, right - ASP and maybe ADO? I bet you built this query in Access and then tried to use it "as is" in your web page. No can do. Access just loves...
Theodore- Switch to SQL view and paste all that you see in a reply. (Open your query in Design view, then choose SQL View from the View menu.) John Viescas,...
I am using 2003. And you remember the way my database is set up probably. Thanks! ... later, ... cellamedina ... At ... percent ... February, ... want...
Ove- I would guess you're missing the "linking" value in one of the tables. INNER JOIN returns only the records where there are matching values in both tables....
Tammy- You need to build a query that returns the data to plot - it doesn't need to be a Crosstab. Start a new form using that query as the Record Source, add...
John, I checked once more and did also rebuild the query without succeeding. I have a main tbl, called Huvudtabell, and three related tables used for looking...
Ove- This is made more difficult if you've defined Lookup fields in table Huvudtabell. Open that table in Design view and change the Display Control on the...
John, Sorry to be bugging you on this . . .but it's still not working :( I'm putting this in Private Sub Command11_Click() DoCmd.OpenReport "Search by Site ID...
Dawn- Fudge. I missed the blank in the field name as well. That's why I strongly recommend against blanks in field names. Here's the first one fixed: ...
Good catch, John. And, most likely, you don't need the parens around the first inner join as well. ADO should be able to parse without them. In most cases, you...
Will I be able to break down by month that way? ... doesn't need to ... Source, add ... text boxes, ... drop the ... Design ... Save ... Master / Link ... ...
Tammy- If you include a "Month" field in the query, then yes. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access...
John, Wow! I'm loving what I'm seeing so far. I made a new query with just the information I need to plot and I took out the Between[]and[] criteria on the...
Tammy- Percentages should be calculated in your query. Drag your Month field to the area labeled "Drop Category Fields Here" along the bottom. Drag your ...
John, I'm almost there. For some reason I cannot use the expression "Expr1: Sum([stotals])/Sum([stotals]+[utotals])" to calculate the percentage in the query....
John, I checked if I had used all lookup fields. I had not. After entering a choice on all of them I got all 3 records on the list. Thanks. Is there a...
Tammy- Post the entire SQL from the query. John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office...
I have tried to get a PM field to show up as a box in a report, which prints all fields of a record per page. It looks OK in design view but it is not printed...
Ove- In the table, you can set a Validation Rule and Validation Text. Validation Rule: Is Not Null Validation Text: You must select a value for the xxx...
OK, John. Here it is. Another alternative I thought of was adding a public function to the module. That's where STotal and UTotal come from. But I don't know...
Ove- By a "PM" field to you mean a field displaying a time? Although Access Report Design is supposed to be WYSIWYG, it's not exactly. I often find, ...
Tammy- What's in qryCM, qryCMRptTotals, and qryCMPer? Why do you need qryCM and tblSupers if you're not outputting any columns from these? John Viescas,...
John, Sorry, I was a bit careless in translating. PM stands for promemoria (pro memoire?), that I thought was more or less universal. In your book I see the ...
Ove- I've never seen fields overlapping another field. I would have to see the report, but if you've come up with a workaround, then so be it. If you'd like...
Hello, The error that I am getting is that invalid use of operator for ON A. FolderID = B.FolderID UPDATE Folder AS A INNER JOIN (SELECT 'AddFolder,' &...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
