I work with floor plans that were on Excel 97. We just migrated to XP and I can no longer select them to be printed on Tabloid paper. Can anyone tell me if this is an option in XP?
Can you take 5 different queries with field names that are the same but that the data in these fields are not linked in any way? The five queries each have one table that is the same (Table 1)and each has one table (First query has table 1 & table 2, second query has table 1 & table 3, and so...
Thanks to Neufarth (MIS) for your helpful hint to Select Predicates in Access Help. But how would I write the instructions if I want all the entries along with just 1 of each duplicate entry? When I used the Sub query Select Distinct it gives me the duplicates only, not the rest of the entries...
I have a table in access that is fed directly from a system. the fields in the table refer to cases opened, worked, and then closed in this particular system. Each case has a specific number that is unique to the case but that case can be opened more than once and the case number stays the same...
I am working in a database that has tables that contain case types (text field) and the number of case types closed (unbound field) for individual employees. Each month a report will be generated for each employee with the total numbers of each case closed for their productivity. (There is other...
I am running a report that has case types as text names and the number of those case types closed in the unbound field. What I would like to do is run a report that will not show those text names if the number (in the unbound field) is 0. Is that possible or is the report like a template that...
I would like to add a column in my query that asks the question if a certain field in my query is < or = to 5 then the number 184 should be entered if not then 224 should be entered. How do I build the the expression? The field I am refering to is Years of service (in a specific company) that...
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.