underlying

I have a union query pulling information from two underlying tables. The underlying tables are using lookups to display a name instead of the primary key, so the data pulled in to the union query is the unique ID (numerical value). Is it possible to edit the SQL code in the union query to...

I have a curious challenge I'm trying to overcome and I could do with some support. I'm converting a set of data that consists of timesheet information into a table using vba. The column headings pre-conversion are in date format, but the underlying data is a number (i.e. if I convert it into a...

Howdy I have been provided with an Access database (mdb format) which links to - I believe - many underlying SQL Svr tables/views/queries in at least one (possibly more) SQL Svr tables. My problem is that I don't have MS Access installed in my environment. Whilst I can request it, I probably...

Hello All, With a filtered pivot table, is it possible to show item percentages of all the underlying data ... i.e. the % will not sum to 100%. Thank you, David

How do I write a formula to return the row# of a cell that is referenced by another cell and I must go through that other cell to learn what cell it is referencing. In other words: IF: "Other"!B3=4 then A1="other"!B3=4 I want to use cell C1 to Find Row("other"!B3) or to show "3", but C1...