Re: Is this join valid? ... > complex set of tables and queries, but I've boiled down the behavior ... you describe a problem with the Design View that really should not ... affect what happens when running a query from ASP. ... > the SQL view after creating the query in Design View. ... (microsoft.public.inetserver.asp.db)
Re: query to combine values if true ... What if you keep your data tables in a well-normalized form (to help Access... you can give them a form and a way to query and they'd be ... i am open to suggestions of a better design.... (microsoft.public.access.gettingstarted)
Re: query where end user puts in selection criteria ... I'd like for a user to be able to select specific competencies so ... am used to working in design view and building queries for myself but this is ... build their own query from a form. ..."Duane Hookom" wrote: ... (microsoft.public.access.gettingstarted)
Re: bypassing some of the parameters in a parameter query ... >> Well, WHERE does work in design view, but having a lot of ANDs and ORs ... what is simple and direct logic in SQL View ... >> query to design view and see if it makes sense to you. ... >> Tom Ellison... (microsoft.public.access.queries)
Re: Display data from 2 tables in 1 grid? ... with one table of members' names, then each sales... add a second instance of the Names table to the Query...Design mode, I right clicked on the form and a menu ... including scouring Help files for the various programs. ... (microsoft.public.vb.database)
